Databricks Certified Data Engineer - Associate

Explanation

In Databricks SQL, alerts can be configured to notify users when query results meet certain conditions. The scenario describes:

1. A Databricks SQL query that returns the number of records with unexpected NULL values
2. A requirement to notify the entire team via a messaging webhook when this value reaches 100

Let's analyze each option:

A. They can set up an Alert with a custom template.

• Custom templates allow formatting of alert messages but don't determine the delivery method
• This doesn't address the webhook notification requirement

B. They can set up an Alert with a new email alert destination.

• This would send notifications via email, not via a messaging webhook
• Email destinations are different from webhook destinations

C. They can set up an Alert with a new webhook alert destination. ✅ CORRECT

• Databricks SQL alerts support webhook destinations for sending notifications to external services
• The data engineer can create a webhook alert destination configured with their team's messaging webhook URL
• When the alert condition (NULL count ≥ 100) is met, the alert will trigger and send a notification via the webhook

D. They can set up an Alert with one-time notifications.

• One-time notifications refer to how often alerts are sent, not the delivery method
• This doesn't specify how the notification reaches the team (webhook vs other methods)

Key Concepts:

1. Databricks SQL Alerts: Allow monitoring query results and triggering notifications based on conditions
2. Alert Destinations: Define where alerts are sent (email, webhook, etc.)
3. Webhook Destinations: Configure alerts to send HTTP POST requests to specified URLs, enabling integration with messaging platforms like Slack, Teams, etc.
4. Alert Conditions: Can be set to trigger when query results meet specific thresholds (e.g., value ≥ 100)

The correct approach is to create a webhook alert destination configured with the team's messaging webhook URL, then set up an alert on the query with the condition that triggers when the NULL count reaches 100.