Ultimate access to all questions.
Answer-first summary for fast verification
Answer: They can set up an Alert with a new webhook alert destination.
## Explanation The correct answer is **D** because: 1. **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. 2. **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 3. **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. 4. **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.
Author: Keng Suppaseth
No comments yet.
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?
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.