DEA-C02 Question #105: Real Exam Question with Answer & Explanation

Question

How can a Data Engineer track credit consumption related to the use of Data Metric Functions (DMFs)? Query the table function.

Options

• ADATABASE_STORAGE_USAGE_HISTORY
• BQuery the DATA_QUALITY_MONITORING_USAGE_HISTORY view.
• CQuery the DATABASE_STORAGE_USAGE_HISTORY view.
• DQuery the table function.

Explanation

DATA_QUALITY_MONITORING_USAGE_HISTORY is a dedicated view in Snowflake's ACCOUNT_USAGE schema that tracks credit consumption specifically tied to Data Metric Function evaluations, making it the correct tool for this monitoring task. Option A and C both reference DATABASE_STORAGE_USAGE_HISTORY, which tracks storage consumption (bytes used by databases), not compute credits from DMF execution - a common trap since "usage history" appears in both names. Option D ("Query the table function") is a fragment of the question stem rephrased as an answer, not a real Snowflake object.

Memory tip: Think "Data Quality = Data Quality view" - DATA_QUALITY_MONITORING_USAGE_HISTORY maps directly to the feature it monitors. If a Snowflake question asks about tracking credits for a specific feature, look for a _USAGE_HISTORY view named after that feature, not a generic storage view.

No community discussion yet for this question.