Snowflake
DEA-C02 · Question #139
A Data Engineer needs to monitor the quality of hr.tables.employee_dim using a Data Metric Function (DMF). Which DMF will return the percent of NULL values for the passport column in table employee_di
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #139. The question stem and answer options stay visible for context.
Security and Governance
Question
A Data Engineer needs to monitor the quality of hr.tables.employee_dim using a Data Metric Function (DMF). Which DMF will return the percent of NULL values for the passport column in table employee_dim?
Options
- ASELECT SNOWFLAKE.CORE.NULL_COUNT(SELECT passport FROM
- BSELECT SNOWFLAKE.CORE.AVG(SELECT passport FROM hr.tables.employee_dim);
- CSELECT SNOWFLAKE.CORE.BLANK_COUNT(SELECT passport FROM
- DSELECT SNOWFLAKE.CORE.NULL_PERCENT(SELECT passport FROM
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Data Metric Functions (DMF)#Data Quality#NULL handling#Snowflake Core Functions