Which of the following table is used in management data warehouse sche – McqOptions

MCQOPTIONS

1.	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

Discussion

No Comment Found

Related MCQs

WHAT_DOES_COLLECTOR_TYPE_ID_STANDS_FOR_IN_THE_FOLLOWING_CODE_SNIPPET_??$
Which of the following is syntax for sp_add_collector_type procedure ?
Which of the following table is used in management data warehouse schema that is required for the Server Activity ?
____________ stores information about how the management data warehouse reports should group and aggregate performance counters.
Which of the following is best Practice and Caveat for Management Data Warehouse ?
Which of the following scenario favours cached mode ?
Which of the following mode allows for the collection and uploading of data to occur on demand ?
_________ introduces the Management Data Warehouse (MDW) to SQL Server Management Studio for streamlined performance troubleshooting.