Free DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Web TestEngine Demo

Q20 Single choice

A data engineering team uses Databricks Lakehouse Monitoring to track the percent_null metric for a critical column in their Delta table. The profile metrics table (prod_catalog.prod_schema.customer_data_profile_metrics) stores hourly percent_null values. The team wants to trigger an alert when the daily average of percent_null exceeds 5% for three consecutive days, while ensuring notifications aren't spammed during sustained issues.

Which SQL alert configuration achieves this goal while minimizing false positives and redundant notifications?

A
SELECT AVG(percent_null) AS daily_avg FROM prod_catalog.prod_schema.customer_data_profile_metrics WHERE window.end >= CURRENT_TIMESTAMP - INTERVAL '3' DAY Alert Condition: daily_avg > 5 Notification Frequency: Each time alert is evaluated
B
SELECT percent_null FROM prod_catalog.prod_schema.customer_data_profile_metrics WHERE window.end >= CURRENT_TIMESTAMP - INTERVAL '1' DAY Alert Condition: percent_null > 5 Notification Frequency: At most every 24 hours
C
SELECT SUM(CASE WHEN percent_null > 5 THEN 1 ELSE 0 END) AS violation_days FROM prod_catalog.prod_schema.customer_data_profile_metrics WHERE window.end >= CURRENT_TIMESTAMP - INTERVAL '3' DAY Alert Condition: violation_days >= 3 Notification Frequency: Just once
D
WITH daily_avg AS (SELECT DATE_TRUNC('DAY', window.end) AS day, AVG (percent_null) AS avg_null FROM prod_catalog.prod_schema.customer_data_profile_metrics GROUP BY DATE_TRUNC ('DAY', window.end) ) SELECT day, avg_null FROM daily_avg ORDER BY day DESC LIMIT 3 Alert Condition: ALL avg_null > 5 for the latest 3 rows Notification Frequency: Just once

DATABRICKS-CERTIFIED-PROFESSIONAL-DATA-ENGINEER Web TestEngine demo