
Ultimate access to all questions.
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.
Explanation:
Correct Answer: C - They can set up an Alert with a new webhook alert destination.
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.
Alert Configuration: The data engineer can:
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.
This approach enables automated monitoring of data quality metrics and team-wide notifications through their preferred messaging platform.