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

Q22 Single choice

A data engineering team needs to create a SQL Alert that monitors data quality across multiple columns in their customer table. They want to trigger an alert when both the percentage of customers with missing email addresses exceeds 15% AND the percentage of customers with invalid phone number formats exceeds 10%.

Which SQL query pattern is appropriate for implementing this multi-column alert condition?

A
SELECT COUNT(*)
FROM customers
WHERE email IS NULL
OR phone_format_invalid = true;
B
SELECT email, phone
FROM customers
WHERE email IS NULL
AND phone NOT RLIKE '[0-9-+()\\s]+$';
C
SELECT email_null_pct, phone_invalid_pct
FROM (
SELECT
COUNT(CASE WHEN email IS NULL THEN 1 END) * 100.0 / COUNT(*) AS email_null_pct,
COUNT(CASE WHEN phone NOT RLIKE '[0-9-+()\\s]+$' THEN 1 END) * 100.0 / COUNT(*) AS phone_invalid_pct
FROM customers
);
D
SELECT CASE
WHEN email_null_pct > 15
AND phone_invalid_pct > 10
THEN 1
ELSE 0
END
FROM (
SELECT
COUNT(CASE WHEN email IS NULL THEN 1 END) * 100.0 / COUNT(*) AS email_null_pct,
COUNT(CASE WHEN phone NOT RLIKE '[0-9-+()\\s]+$' THEN 1 END) * 100.0 / COUNT(*) AS phone_invalid_pct
FROM customers
) metrics;

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