MS SQL Server - 91 - Reporting Services (SSRS) MCQ

91 – Reporting Services (SSRS) MCQ

1 / 25

1. What is SQL Server Reporting Services (SSRS) primarily used for?

C. Data reporting

D. Data encryption

A. Data storage

B. Data analysis

2 / 25

2. Which component of SSRS is responsible for designing and generating reports?

B. Report Server

C. Report Designer

A. Report Builder

D. Report Viewer

3 / 25

3. What is the file extension used for SSRS report definition files?

D. .xml

A. .ssrs

C. .rdl

B. .rpt

4 / 25

4. Which programming language is commonly used for creating custom expressions and code in SSRS reports?

A. C#

C. Java

B. Python

D. SQL

5 / 25

5. In SSRS, what is a parameter used for in a report?

A. To define the report layout

D. To schedule report delivery

B. To specify the data source

C. To allow users to filter and customize report data

6 / 25

6. Which type of SSRS report parameter allows users to select multiple values from a list?

D. Numeric

C. Boolean

A. Single-value

B. Multi-value

7 / 25

7. What is the purpose of the Report Data window in SSRS Report Builder?

B. To define report parameters

C. To specify data sources and datasets

D. To preview the report

A. To design report layouts

8 / 25

8. In SSRS, what is a data source?

D. A connection to an external data store

A. A graphical representation of a report

B. A connection to the report server

C. A dataset that defines report data

9 / 25

9. Which SSRS component is responsible for managing and storing reports, as well as handling report subscriptions?

D. Report Viewer

C. Report Designer

B. Report Server

A. Report Builder

10 / 25

10. What is the primary function of the SSRS Report Manager?

C. Creating data sources

A. Designing reports

B. Viewing and managing reports

D. Writing custom code for reports

11 / 25

11. In SSRS, what is the purpose of a dataset?

B. To design report layouts

A. To define report parameters

C. To specify the data source

D. To retrieve and structure report data

12 / 25

12. Which SSRS feature allows you to create interactive, clickable elements in a report that navigate to other parts of the report or external URLs?

C. Tablix

B. Drillthrough reports

A. Subreports

D. Parameters

13 / 25

13. What is a Tablix in SSRS?

A. A report parameter

B. A data source

D. A report subscription

C. A report layout element that can display data in a table, matrix, or list format

14 / 25

14. In SSRS, what is a Subreport?

D. A data source

B. A report layout element that displays related data in a nested report

C. A report subscription

A. A report parameter

15 / 25

15. Which SSRS component is used for viewing and rendering reports within applications or web portals?

A. Report Builder

B. Report Server

C. Report Designer

D. Report Viewer

16 / 25

16. In SSRS, what is a Report Snapshot?

A. A saved copy of a report that includes data at a specific point in time

B. A report parameter

D. A report subscription

C. A report layout element

17 / 25

17. What is the purpose of a shared dataset in SSRS?

B. To design report layouts

C. To create data sources

A. To define report parameters

D. To reuse a dataset across multiple reports

18 / 25

18. In SSRS, what is a data-driven subscription?

B. A report layout element

D. A subscription that uses dynamic data to determine report recipients and delivery options

C. A report parameter

A. A type of dataset

19 / 25

19. What is the Report Parts feature in SSRS used for?

D. To schedule report delivery

A. To create data sources

C. To reuse report components across multiple reports

B. To define report parameters

20 / 25

20. Which SSRS rendering extension is used to export a report to PDF format?

C. HTML

D. PDF

A. CSV

B. Excel

21 / 25

21. In SSRS, what is the purpose of a report parameter dataset?

C. To create data sources

D. To retrieve parameter values from a data source

B. To design report layouts

A. To define report parameters

22 / 25

22. What is the primary purpose of the SSRS Report Wizard?

B. To design report layouts

C. To automate report generation

A. To create complex reports with multiple data sources

D. To guide users through the report creation process

23 / 25

23. Which SSRS component allows you to design and customize reports with a drag-and-drop interface?

A. Report Builder

C. Report Designer

B. Report Server

D. Report Viewer

24 / 25

24. In SSRS, what is a report subscription?

B. A report parameter

A. A type of dataset

D. A scheduled delivery of a report to a specified destination

C. A report layout element

25 / 25

MS SQL Server – 91 – Reporting Services (SSRS) MCQ