This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Reporting Services – 1”.
1. Which of the following tool requires Reporting Services in SharePoint mode?
a) Report Designer
b) Power View
c) Report Builder
d) None of the mentioned
View Answer
Explanation: Power view gives interactive data exploration and visual presentation experience designed to let you create and interact with reports based on Analysis Services tabular models.
2. Point out the correct statement.
a) The tools that you use is independent of the deployment mode of your report server
b) A set of scripting tools are available for administering the report server in SQL Server Reporting Services
c) SQL Server Reporting Services contains a set of graphical and scripting tools that support the development and use of rich reports in a managed environment
d) None of the mentioned
View Answer
Explanation: The tool set includes development tools, configuration and administration tools, and report viewing tools.
3. ______________ does not help you manage report server content, enable additional features, or grant access to the server.
a) Reporting Services Configuration Manager
b) SSMS
c) SQL Server Configuration Manager
d) None of the mentioned
View Answer
Explanation: Reporting Services Configuration Manager is used to configure a Reporting Services installation.
4. __________ is a tool to configure and manage a report server connection to the report server database.
a) Rskeymgmt Utility
b) Windows Management Instrumentation (WMI) Classes
c) Rsconfig Utility
d) None of the mentioned
View Answer
Explanation: You can also use it to specify a user account to use for unattended report processing.
5. Point out the wrong statement.
a) Report Manager works in all modes
b) A report server is a computer that has an instance of Reporting Services installed
c) A report server integrated with SharePoint has two possible configurations
d) All of the mentioned
View Answer
Explanation: Report Manager works in native mode only.
6. Which of the following is a tool for Report Content Management?
a) Report Server Web service URL
b) Rskeymgmt Utility
c) Configuration manager
d) All of the mentioned
View Answer
Explanation: Use Report Server Web service URL tool to browse content in the report catalog in a generic item navigation page.
7. Which of the following mode lets you interact with the report server, reports, and report related items by using a browser with Report Manager or URL access commands?
a) SharePoint mode report server
b) Native
c) SSRS
d) All of the mentioned
View Answer
Explanation: A report server configured in native mode is a computer that has SQL Server Reporting Services installed and configured as a stand-alone server.
8. Reports use __________ to retrieve data for a report when a query runs or when the report is processed.
a) Data connections
b) Data source definition
c) Connection string
d) All of the mentioned
View Answer
Explanation: A data connection includes a name and connection properties that are dependent on the connection type.
9. A _________ is an item stored internally in an alerting database.
a) Connection string
b) Data alert
c) Shared data source
d) None of the mentioned
View Answer
Explanation: A data alert definition includes which data to use from existing report data feeds, the conditions to be met, a schedule.
10. A __________ is a report server item that contains a pointer to the report definition.
a) Drilldown report
b) Linked report
c) Subreport
d) Drillthrough report
View Answer
Explanation: Linked reports include security, parameters, location, subscriptions, and schedules.
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.
If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]- Check Information Technology Books
- Practice Programming MCQs
- Apply for Programming Internship
- Check SQL Server Books
