
Explanation:
The question asks for two options to view warehouse usage over time. Option D (WAREHOUSE_METERING_HISTORY view) is correct because it is an Account Usage view that provides hourly credit usage for warehouses over the last 365 days, directly tracking usage over time. Option E (billing and usage tab in the Snowflake web UI) is correct as it offers a graphical interface in Snowsight to explore compute costs and usage patterns over time. The community discussion strongly supports D and E with 91% consensus and multiple comments citing official documentation. Option A (LOAD HISTORY view) is incorrect as it tracks data loading, not warehouse usage. Option B (query history view) shows queries but not aggregated usage metrics over time. Option C (SHOW WAREHOUSES command) displays current warehouse status, not historical usage.
Which two options can be used to view warehouse usage over time?
A
The LOAD HISTORY view
B
The query history view
C
The SHOW WAREHOUSES command
D
The WAREHOUSE_METERING_HISTORY view
E
The billing and usage tab in the Snowflake web UI
No comments yet.