Databricks Certified Data Engineer Associate — Question 46

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?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D, as setting up an Alert with a new webhook alert destination allows the data engineer to notify the entire team directly through the webhook whenever the specified condition is met. Options A, B, C, and E do not provide the capability to notify the team via a messaging webhook, as they focus on custom templates, email notifications, one-time alerts, or no notifications at all.