Databricks Data Engineer Associate Question 464
Select 2A data engineering team has set up a Databricks SQL query to monitor the daily sales data for anomalies. They want to configure an alert that notifies the team via email whenever the query results exceed a certain threshold. Which of the following configurations will ensure that the alert is sent to the team via email?
- A
Add the team's email addresses to the alert notification settings.
- B
Enable the 'Email Notifications' option when creating the alert.
- C
Configure the alert to trigger on a specific condition in the query results.
- D
Ensure that the query is scheduled to run periodically.
- E
Set up a webhook integration for email delivery.
Show answer and explanation
Correct answers: A, B
Explanation
To ensure that alerts are sent via email in Databricks, it is necessary to add the recipients' email addresses to the alert configuration and enable the 'Email Notifications' option. While other configurations like setting conditions and scheduling queries are important for alert functionality, they are not directly related to email delivery.
- A. Correct.
Correct: Adding the team's email addresses ensures the alert is sent to the correct recipients when triggered.
- B. Correct.
Correct: Enabling the 'Email Notifications' option is required to send the alert notification via email.
- C. Incorrect.
Incorrect: While configuring a condition for the alert is necessary, it does not specifically address sending the alert via email.
- D. Incorrect.
Incorrect: Scheduling the query ensures it runs periodically but does not relate to configuring email alerts.
- E. Incorrect.
Incorrect: Webhook integration is not required for sending email notifications, as email functionality is built into Databricks Alerts.