Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to a data analytics dashboard for a retail use case. The job has a Databricks SQL query that returns the number of store-level records where sales is equal to zero. The data engineer wants their entire team to be notified via a messaging webhook whenever this value is greater than 0.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of stores with $0 in sales is greater than zero?
Real Exam
Community
KKeng
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 one-time notifications.
D
They can set up an Alert with a new webhook alert destination.
E
They can set up an Alert without notifications.
Explanation:
Explanation
The correct answer is D because:
-
Webhook Alert Destination: The requirement specifically asks for notification via a messaging webhook. In Databricks SQL, alerts can be configured with different notification destinations, including webhooks. Setting up a new webhook alert destination allows the alert to send notifications to a webhook URL, which can then forward the message to a messaging platform (like Slack, Microsoft Teams, etc.).
-
Why other options are incorrect:
- A (custom template): Custom templates allow formatting of alert messages but don't determine the delivery method. You still need a destination.
- B (email alert destination): This would send notifications via email, not via a webhook as requested.
- C (one-time notifications): This refers to notification frequency, not the delivery method.
- E (without notifications): This would not send any notifications at all, which contradicts the requirement.
-
Implementation Steps:
- Create an alert on the Databricks SQL query
- Configure the alert condition (when count > 0)
- Add a new webhook destination
- Provide the webhook URL from the messaging platform
- The alert will trigger and send a POST request to the webhook when the condition is met
This approach enables real-time team notifications through their preferred messaging platform whenever data quality issues are detected.
Comments
Loading comments...