Question

____________ 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

I had been asked this question in an online interview.

My doubt stems from Management Data Warehouse in chapter Monitoring and Auditing of SQL Server

Answer 1

Right option is (d) core.performance_counter_report_group_items

The explanation is: core.wait_categories contains the categories used to group wait types according to wait_type characteristic.