Explanation:core.wait_categories contains the categories used to group wait types according to wait_type characteristic. 8. 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:A
Explanation:core.wait_categories contains the categories used to group wait types according to wait_type characteristic. 8. 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
Explanation:snapshots.os_latch_stats is a System level resource table. 9. Which of the following is syntax for sp_add_collector_type procedure ?