SQL Server Questions and Answers – Reporting Services – 2

This set of SQL Server Assessment Questions and Answers 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

Answer: d
Explanation: The drillthrough report opens separately from the main report. A hyperlink can be defined on any report item that has an Action property.

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

Answer: c
Explanation: Report history is not intended for reports that contain confidential or personal data.

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

Answer: a
Explanation: Export formats depend on installed rendering extensions and can be customized. By default, export formats include Excel, Word, XML, PDF, TIFF, and CSV.

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

Answer: b
Explanation: Name is a property with a string text value.

advertisement
advertisement

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

Answer: b
Explanation: Cached reports are used to improve performance by reducing the number of processing requests to the report processor and by reducing the time that is required to retrieve large report datasets.

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

Answer: a
Explanation: Schedule operations are not available in every edition of SQL Server.

Note: Join free Sanfoundry classes at Telegram or Youtube

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

Answer: b
Explanation: Shared schedules are system-level items, creating a shared schedule requires system-level permissions.

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

Answer: b
Explanation: The Scheduling and Delivery Processor requires that the Report Server service and SQL Server Agent are started.

advertisement

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

Answer: a
Explanation: ReportingService2010.FireEvent Method raises an event based on the supplied parameters.

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

Answer: a
Explanation: ExecutionLog3 view added additional performance diagnostics node inside the XML based AdditionalInfo column.

advertisement

Sanfoundry Global Education & Learning Series – SQL Server.

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

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.