Databricks Data Engineer Associate Question 465
Select 2You are a data engineer tasked with monitoring the performance of a table in Databricks SQL. You want to set up an alert to notify your team via email whenever the table's query execution time exceeds a specific threshold. Which of the following steps should you take to achieve this?
- A
Create a query in Databricks SQL to monitor the desired metric and save it as a dashboard.
- B
Create an alert and specify the condition for query execution time exceeding the threshold.
- C
Configure the alert's notification settings to send an email to your team members.
- D
Enable the 'Run as Owner' option to ensure the alert runs with appropriate permissions.
- E
Export the alert configuration as a JSON file and upload it to the workspace.
Show answer and explanation
Correct answers: B, C
Explanation
To send an email alert when a specific condition is met (e.g., query execution time exceeds a threshold), you need to configure an alert in Databricks SQL. This includes defining the condition and setting up email notifications. Other steps, like creating dashboards or exporting configurations, are not directly related to this task.
- A. Incorrect.
Creating a query or dashboard is useful for monitoring, but it is not directly required to configure an alert. Alerts can be set up independently of dashboards.
- B. Correct.
This is correct because configuring the alert condition is essential for triggering notifications based on specific metrics like query execution time.
- C. Correct.
This is correct because configuring the notification settings to send an email ensures that your team is alerted when the condition is met.
- D. Incorrect.
This option is unrelated to setting up an alert. 'Run as Owner' is used for access control but does not affect alert configuration.
- E. Incorrect.
Exporting the alert configuration as JSON is not relevant to sending email alerts. It is also not a required step for this task.