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 question specifically states that the data engineer wants to notify their team "via a messaging webhook." In Databricks SQL, Alerts can be configured with different notification destinations, including webhooks.
-
Alert Functionality: Databricks SQL Alerts allow users to monitor query results and trigger notifications when certain conditions are met. When setting up an alert, you can configure:
- Alert destinations: Where notifications should be sent (email, webhook, etc.)
- Alert conditions: When to trigger notifications (e.g., when result > 0)
- Notification frequency: How often to check and notify
-
Why other options are incorrect:
- A (custom template): Custom templates are for formatting the notification message, not for setting up the delivery mechanism to a webhook.
- 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 mechanism. Alerts can be configured for one-time or recurring notifications regardless of the destination.
- E (without notifications): This contradicts the requirement to notify the team.
-
Implementation Steps:
- Create an Alert on the Databricks SQL query
- Set the condition to trigger when the query result (number of stores with $0 sales) > 0
- Add a new webhook alert destination with the messaging webhook URL
- Configure the notification settings as needed
This approach allows the team to receive real-time notifications through their preferred messaging platform (like Slack, Teams, etc.) whenever data quality issues are detected.
Comments
Loading comments...