Which of the following usage metrics is most effective for capacity planning of a data...

Queries per user group per timeframe is the most effective usage metric for capacity planning of a data warehouse. This metric provides detailed insights into the workload generated by differentuser groups over specific periods, allowing for accurate forecasting of resource needs and planning for future capacity. It helps in identifying patterns and peak usage times, which are crucial for efficient capacity management.

References:

"Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems" by Sam Anahory and Dennis Murray

"The Data Warehouse Lifecycle Toolkit" by Ralph Kimball et al.