SnowPro Advanced: Data Engineer — Question 119

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?

Answer options

• A. SELECT SNOWFLAKE.CORE.NULL_COUNT(SELECT passport FROM hr.tables.employee_dim)/100;
• B. SELECT SNOWFLAKE.CORE.AVG(SELECT passport FROM hr.tables.employee_dim);
• C. SELECT SNOWFLAKE.CORE.BLANK_COUNT(SELECT passport FROM hr.tables.employee_dim);
• D. SELECT SNOWFLAKE.CORE.NULL_PERCENT(SELECT passport FROM hr.tables.employee_dim);

Correct answer: D

Explanation

The correct answer is D, as the NULL_PERCENT function specifically calculates the percentage of NULL values in a given column. Option A provides a count of NULLs rather than a percentage, while option B calculates the average and option C counts blank entries, neither of which are relevant to finding the percentage of NULLs.