SQL Server Questions and Answers – Reporting Services – 2

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Reporting Services – 2”.

1. A _________ report solution includes a main report that displays summary information with hyperlinks to one or more reports that display detailed information.
a) Main
b) Detail
c) Drillthrough
d) All of the mentioned
View Answer

2. Point out the correct statement.
a) A published report is a report definition (.rdl) file
b) A saved report is a published report definition that is converted to a newer schema when a report server is upgraded
c) Report history is a collection of report snapshots
d) All of the mentioned
View Answer

3. An ___________ report is a fully paged report saved in a specific file format.
a) exported
b) fully processed
c) compiled
d) all of the mentioned
View Answer

4. Which of the following is a list type in RDL with base 64 encoded value?
a) Boolean
b) Binary
c) Enum
d) Name
View Answer

5. Point out the wrong statement.
a) A report snapshot is a report that contains layout information and query results that were retrieved at a specific point in time. Unlike on-demand reports
b) A detailed report is a saved copy of a compiled report and report data
c) A report model is a user-friendly description of an underlying database, with pre-established data relationships and auto-generated queries
d) All of the mentioned
View Answer

6. You can use Report Manager in ________ mode and SharePoint site administration pages in ________ mode.
a) Native, Sharepoint
b) Sharepoint, Native
c) Native, Native
d) Sharepoint, Sharepoint
View Answer

7. __________ are portable, multipurpose items that contain ready-to-use schedule information.
a) Report-specific schedule
b) Shared schedules
c) File schedules
d) None of the mentioned
View Answer

8. The Schedule and Delivery Processing feature must be enabled through the ____________ property.
a) ScheduleEventsDeliveryEnabled
b) ScheduleEventsAndReportDeliveryEnabled
c) ScheduleEventsAndReportDelivery
d) All of the mentioned
View Answer

9. The functionality that SQL Server Agent provides to Reporting Services can be replaced with custom code that uses the _________ method to add schedule events to the queue.
a) FireEvent
b) FireEventdata
c) Eventdata
d) None of the mentioned
View Answer

10. Which of the following statement is used to retrieve rows from the view ExecutionLog3?
a) select * from ExecutionLog3 order by TimeStart DESC
b) select * from ExecLog3 order by TimeStart DESC
c) select * from ExecutionLog4 order by TimeStart DESC
d) none of the mentioned
View Answer

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.