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 states that the team should be notified via a messaging webhook. In Databricks SQL, alerts can be configured with different notification destinations, including webhooks.
-
Alert Configuration: When setting up an alert in Databricks SQL, you can:
- Define the condition (when the query result > 0)
- Configure notification destinations
- Add a webhook destination to send notifications to messaging platforms like Slack, Microsoft Teams, etc.
-
Why other options are incorrect:
- A (custom template): Custom templates allow formatting of alert messages but don't address the webhook delivery mechanism.
- B (email alert destination): This would send notifications via email, not via a messaging webhook.
- C (one-time notifications): This refers to notification frequency, not the delivery method via webhook.
- E (without notifications): This would not send any notifications at all, which contradicts the requirement.
-
Implementation Steps:
- Create an alert on the SQL query
- Set the condition: "When result > 0"
- Add a new webhook alert destination
- Configure the webhook URL for the messaging platform
- The alert will trigger when the query returns a value > 0 and send a notification via the webhook to the team's messaging channel.
Comments
Loading comments...