SnowPro Advanced: Data Engineer — Question 103

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
) ;

When the query is run, an error is returned.

What is causing the error?

Answer options

• A. DMFs can only be defined on a table; they cannot be executed as a SQL statement.
• B. snowflake_sample_data.tpch_sf1.customer is in a data share, which is not a valid source for DMFs.
• C. The SNOWFLAKE.CORE.MAX() function cannot accept VARCHAR arguments.
• D. The SNOWFLAKE.CORE.MAX() function is not a valid Snowflake DMF.

Correct answer: D

Explanation

The correct answer is D because the SNOWFLAKE.CORE.MAX() function is not classified as a Data Metric Function in Snowflake. Options A, B, and C are incorrect because they do not accurately describe the root cause of the error related to the classification of the function being used.