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. |
WHAT_DOES_COLLECTOR_TYPE_ID_STANDS_FOR_IN_THE_FOLLOWING_CODE_SNIPPET_??$ |
| A. | |
| B. | uniqueidentifier |
| C. | membership role |
| Answer» B. uniqueidentifier | |
| 2. |
Which of the following is syntax for sp_add_collector_type procedure ? |
| A. | core.sp_add_collector [ @collector_type_uid = ] ‘collector_type_uid’ |
| B. | core.sp_add_collector_type [ @collector_type_uid = ]. |
| C. | core.sp_add_collector_type [ @collector_type_uid = ] ‘collector_type_uid’ |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 3. |
Which of the following table is used in management data warehouse schema that is required for the Server Activity ? |
| A. | snapshots.query_stat |
| B. | snapshots.os_latch_stats |
| C. | snapshots.active_sessions |
| D. | all of the mentioned |
| Answer» C. snapshots.active_sessions | |
| 4. |
____________ stores information about how the management data warehouse reports should group and aggregate performance counters. |
| A. | core.snapshots_internal |
| B. | core.supported_collector_types_internal |
| C. | core.wait_categories |
| D. | core.performance_counter_report_group_items |
| Answer» E. | |
| 5. |
Which of the following is best Practice and Caveat for Management Data Warehouse ? |
| A. | Use a centralized server for the MDW database |
| B. | The XML parameters for a single T-SQL collection item can have multiple <Query> elements |
| C. | Use a distributed server for the MDW database |
| D. | All of the mentioned |
| Answer» B. The XML parameters for a single T-SQL collection item can have multiple <Query> elements | |
| 6. |
Which of the following scenario favours cached mode ? |
| A. | Continuous collection of data |
| B. | Less frequent uploads |
| C. | Data collection and uploading of jobs on different schedules |
| D. | All of the mentioned |
| Answer» E. | |
| 7. |
Which of the following mode allows for the collection and uploading of data to occur on demand ? |
| A. | Non-cached mode |
| B. | Cached mode |
| C. | Mixed mode |
| D. | All of the mentioned |
| Answer» B. Cached mode | |
| 8. |
_________ introduces the Management Data Warehouse (MDW) to SQL Server Management Studio for streamlined performance troubleshooting. |
| A. | SQL Server 2005 |
| B. | SQL Server 2008 |
| C. | SQL Server 2012 |
| D. | SQL Server 2014 |
| Answer» C. SQL Server 2012 | |