Answer-first summary for fast verification
Answer: They can set up an Alert with a new webhook alert destination.
## Explanation **Correct Answer: C** - They can set up an Alert with a new webhook alert destination. ### Why this is correct: 1. **Webhook Alert Destination**: Databricks SQL Alerts support webhook destinations, which allow you to send notifications to external messaging services (like Slack, Microsoft Teams, etc.) via HTTP POST requests. 2. **Alert Configuration**: The data engineer can: - Create an Alert on the Databricks SQL query that returns the number of NULL values - Set the condition to trigger when the value reaches 100 - Configure a webhook alert destination pointing to their team's messaging service webhook URL - The entire team will receive notifications through their messaging platform ### Why other options are incorrect: **A. Custom template**: While alerts can have custom templates for messages, this alone doesn't solve the webhook notification requirement. Custom templates modify the message format but don't determine the delivery method. **B. Email alert destination**: This would send notifications via email, not via a messaging webhook as specified in the requirement. **D. One-time notifications**: This refers to notification frequency settings (one-time vs. recurring), not the delivery method. The question specifically asks about webhook delivery. ### Key Databricks Concepts: - **Databricks SQL Alerts**: Monitor query results and trigger notifications based on conditions - **Alert Destinations**: Configure where alerts are sent (email, webhook, etc.) - **Webhook Integration**: Connect Databricks to external services for real-time notifications This approach enables automated monitoring of data quality metrics and team-wide notifications through their preferred messaging platform.
Author: Keng Suppaseth
Ultimate access to all questions.
No comments yet.
A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to an ELT job. The ELT job has its Databricks SQL query that returns the number of input records containing unexpected NULL values. The data engineer wants their entire team to be notified via a messaging webhook whenever this value reaches 100.
Which approach can the data engineer use to notify their entire team via a messaging webhook whenever the number of NULL values reaches 100?
A
They can set up an Alert with a custom template.
B
They can set up an Alert with a new email alert destination.
C
They can set up an Alert with a new webhook alert destination.
D
They can set up an Alert with one-time notifications.