COF-C02 · Question #256
Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
The correct answer is C. Information_schema.warehouse_load_history. INFORMATION_SCHEMA.WAREHOUSE_LOAD_HISTORY provides metrics on virtual warehouse activity including queued load, active load, and blocked queries over time. This view is specifically designed to help identify query queuing and performance bottlenecks. WAREHOUSE_METERING_HISTORY…
Question
Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
Options
- AResource monitor
- BAccount_usage. query_history
- CInformation_schema.warehouse_load_history
- DInformation schema.warehouse metering history
How the community answered
(57 responses)- A7% (4)
- B2% (1)
- C88% (50)
- D4% (2)
Explanation
INFORMATION_SCHEMA.WAREHOUSE_LOAD_HISTORY provides metrics on virtual warehouse activity including queued load, active load, and blocked queries over time. This view is specifically designed to help identify query queuing and performance bottlenecks. WAREHOUSE_METERING_HISTORY tracks credit consumption, QUERY_HISTORY tracks individual query execution, and Resource Monitors control credit usage - none of these directly surface queuing data the way WAREHOUSE_LOAD_HISTORY does.
Topics
Community Discussion
No community discussion yet for this question.