Q.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
Q.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
Q.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
Q.4
Which of the following is a list type in RDL with baseencoded value?
  • a) Boolean
  • b) Binary
  • c) Enum
  • d) Name
Q.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
Q.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
Q.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
Q.8
The Schedule and Delivery Processing feature must be enabled through the ____________ property.
  • a) ScheduleEventsDeliveryEnabled
  • b) ScheduleEventsAndReportDeliveryEnabled
  • c) ScheduleEventsAndReportDelivery
  • d) All of the mentioned
Q.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
Q.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
0 h : 0 m : 1 s