MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
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 |
| Answer» C. Subreport | |
| 2. |
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 |
| Answer» C. Shared data source | |
| 3. |
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 |
| Answer» B. Data source definition | |
| 4. |
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 |
| Answer» C. SSRS | |
| 5. |
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 |
| Answer» B. Rskeymgmt Utility | |
| 6. |
__________ 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 |
| Answer» D. None of the mentioned | |
| 7. |
______________ 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 |
| Answer» E. | |
| 8. |
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 |
| Answer» C. Report Builder | |