Snowflake SnowPro Core

Get started today

Ultimate access to all questions.

Quick Answer

Answer-first summary for fast verification

Answer: WAREHOUSE_METERING_HISTORY

The WAREHOUSE_METERING_HISTORY function is specifically designed to profile and analyze warehouse credit usage in Snowflake. This function provides detailed information about credit consumption by warehouses over time, making it the correct choice for credit usage analysis. The community discussion shows 100% consensus on option D, with multiple users confirming this is correct and referencing the official Snowflake documentation that specifically describes this function for warehouse credit metering. The other options serve different purposes: AUTOMATIC_CLUSTERING_HISTORY tracks clustering operations, MATERIALIZED_VIEW_REFRESH_HISTORY monitors view refreshes, and WAREHOUSE_LOAD_HISTORY shows query load patterns, none of which directly provide credit usage profiling.

Author: LeetQuiz Editorial Team

Quick Answer

Answer-first summary for fast verification

Answer: WAREHOUSE_METERING_HISTORY

Author: LeetQuiz Editorial Team

Comments (1)

Ducse ChenOct 15, 2025 12:34 PM

AUTOMATIC_CLUSTERING_HISTORY: is used in queries to return the hourly credit usage for a single warehouse (or all the warehouses in your account) within a specified date range.https://docs.snowflake.com/en/sql-reference/functions/warehouse_metering_history MATERIALIZED_VIEW_REFRESH_HISTORY: is used for querying the materialized views refresh history for a specified materialized view within a specified date range.https://docs.snowflake.com/en/sql-reference/functions/materialized_view_refresh_history WAREHOUSE_LOAD_HISTORY: is used to query the activity history (defined as the “query load”) for a single warehouse within a specified date range. https://docs.snowflake.com/en/sql-reference/functions/warehouse_load_history WAREHOUSE_METERING_HISTORY: is used in queries to return the hourly credit usage for a single warehouse (or all the warehouses in your account) within a specified date range. https://docs.snowflake.com/en/sql-reference/functions/warehouse_metering_history

Which function is used to analyze the credit usage of a warehouse?

Exam-Like

AUTOMATIC_CLUSTERING_HISTORY

0.0%

MATERIALIZED_VIEW_REFRESH_HISTORY

0.0%

WAREHOUSE_LOAD_HISTORY

WAREHOUSE_METERING_HISTORY

100.0%

Powered ByGPT 5.4

Comments (1)

Ducse ChenOct 15, 2025 12:34 PM