What can be used to view warehouse usage over time? (Choose two.)
What can be used to view warehouse usage over time? (Choose two.)
The most appropriate views to understand warehouse usage over time are the WAREHOUSE_METERING_HISTORY view and the billing and usage tab in the Snowflake web UI. The WAREHOUSE_METERING_HISTORY view provides detailed historical data about credit usage on an hourly basis for each warehouse. The billing and usage tab in the Snowflake web UI offers a comprehensive view of usage and costs associated with your account, making it a useful resource for analyzing warehouse usage over time. Other options like the LOAD HISTORY view, query history view, and SHOW WAREHOUSES command do not specifically provide comprehensive historical usage data for warehouses.
Maybe D&E
should be the correct answer
WAREHOUSE_METERING_HISTORY View This Account Usage view can be used to return the hourly credit usage for a single warehouse (or all the warehouses in your account) within the last 365 days (1 year). https://docs.snowflake.com/en/sql-reference/account-usage/warehouse_metering_history.html Snowsight can be used to view complute cost https://docs.snowflake.com/en/user-guide/cost-exploring-compute.html
DE Snowsight can be used to view complute cost https://docs.snowflake.com/en/user-guide/cost-exploring-compute.html
answer is D & E
DE is correct answer query history view specify the wh used but no info about usage consumption
D and E are correct
D And E are correct
A, D : https://medium.com/snowflake/snowflake-warehouse-load-and-metering-analysis-f900e5448c8a
correct
Query history https://docs.snowflake.com/en/sql-reference/account-usage.html#label-account-usage-warehouse-performance-query