SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ75

Ingest and Process Data

A Data Engineer must monitor the 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 returns the percentage of values that are NULL for the column projected by its query. Its argument can be a query that selects the passport column from hr.tables.employee_dim.

Learn more

Community Discussion

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