DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ56

VerifiedOfficial exam objectives/topics

A Data Engineer must monitor the data quality of hr.tables.employee_dim by using a Data Metric Function (DMF).

Which DMF returns the percentage of NULL values in the passport column of the employee_dim table?

Explanation

SNOWFLAKE.CORE.NULL_PERCENT is the Snowflake system data metric function that returns the percentage of values that are NULL in a specified column. It accepts a query that projects that single column, such as passport.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!