A Data Engineer is planning to run a set of Data Metric Functions (DMFs) against a table using this query: select snowflake.core.max( select c_name from snowflake_sample_data.tpch_sf1.customer ) ; Whe

Question

Options

• ADMFs can only be defined on a table; they cannot be executed as a SQL statement.
• Bsnowflake_sample_data.tpch_sf1.customer is in a data share, which is not a valid
• CThe SNOWFLAKE.CORE.MAX() function cannot accept VARCHAR arguments.
• DThe function is not a valid Snowflake DMF.

• B
  6% (1)
• C
  6% (1)
• D
  88% (15)

Explanation

SNOWFLAKE.CORE.MAX does not exist in Snowflake's catalog of built-in Data Metric Functions. Valid system DMFs under the SNOWFLAKE.CORE schema include functions like NULL_COUNT, DUPLICATE_COUNT, ROW_COUNT, and FRESHNESS - all purpose-built for data quality measurement, not SQL aggregation. Option A is wrong because DMFs can be invoked via SQL statements using the appropriate syntax. Option B is wrong because sample data shares are valid targets for DMFs (and the answer itself appears incomplete as written). Option C is a plausible-sounding distractor, but the argument type is irrelevant when the function itself doesn't exist.

Memory tip: DMFs measure data quality (nulls, duplicates, freshness, row counts) - don't confuse them with standard SQL aggregate functions like MAX, MIN, or SUM, which live outside SNOWFLAKE.CORE.

No community discussion yet for this question.