Databricks Data Engineer Associate Question 466
Single answerA data engineering team is using Databricks SQL to monitor a table for any data anomalies. They want to set up an alert that notifies the team via email whenever a query condition is met. What step is required to ensure that the alert is successfully sent via email?
- A
Add the team's email addresses to the 'Recipients' field while creating the alert.
- B
Create a Databricks notebook to manually send an email when the alert condition is triggered.
- C
Enable the 'Email Notification' toggle under the workspace settings.
- D
Configure a webhook integration for email notifications within the Databricks SQL Alerts settings.
Show answer and explanation
Correct answer: A
Explanation
To receive email notifications for an alert in Databricks SQL, the email addresses of the intended recipients must be specified in the 'Recipients' field while configuring the alert. This ensures that the system knows where to send notifications whenever the alert condition is met.
- A. Correct.
This is the correct answer. While creating or editing an alert in Databricks SQL, you must specify the email addresses of the recipients in the 'Recipients' field for email notifications to be sent.
- B. Incorrect.
This is incorrect. Manually sending an email using a notebook is not required or relevant for configuring email alerts in Databricks SQL.
- C. Incorrect.
This is incorrect. There is no 'Email Notification' toggle in the workspace settings for configuring SQL alerts to send emails.
- D. Incorrect.
This is incorrect. Webhook integration is a separate feature in Databricks that is used for sending alerts to external systems, not for sending email notifications directly.