COF-C02 · Question #55
What can be used to view warehouse usage over time? (Select Two).
The correct answer is B. The Query history view D. The WAREHOUSE_METERING__HISTORY View. The two correct tools for viewing warehouse usage over time are: (D) WAREHOUSE_METERING_HISTORY - a view in the ACCOUNT_USAGE schema that records credit consumption per virtual warehouse broken down by hour, making it the definitive source for billing and usage trending; and…
Question
What can be used to view warehouse usage over time? (Select Two).
Options
- AThe load HISTORY view
- BThe Query history view
- CThe show warehouses command
- DThe WAREHOUSE_METERING__HISTORY View
- EThe billing and usage tab in the Snowflake web Ul
How the community answered
(23 responses)- B96% (22)
- C4% (1)
Explanation
The two correct tools for viewing warehouse usage over time are: (D) WAREHOUSE_METERING_HISTORY - a view in the ACCOUNT_USAGE schema that records credit consumption per virtual warehouse broken down by hour, making it the definitive source for billing and usage trending; and (B) Query History - which captures per-query execution details including which warehouse ran each query, execution time, and credits consumed, enabling usage analysis at the query level. Option A (LOAD_HISTORY) tracks data ingestion activity, not warehouse credit usage. Option C (SHOW WAREHOUSES) shows only the current live state of warehouses. Option E (Billing and Usage tab in the UI) reflects billing summaries but is not the specific analytical tool tested here.
Topics
Community Discussion
No community discussion yet for this question.