Databricks Data Engineer Professional · Free practice question 1 of 12
Databricks SQL alerts with notifications
The operations team at Bramwell Energy wants a Slack message whenever the number of rows with a NULL meter_id loaded into energy.silver.readings in the past hour exceeds 500. The check should run every 15 minutes on a SQL warehouse. Which feature fits best?
- A.A NOT NULL constraint on meter_id
- B.A job duration warning threshold
- C.A file arrival trigger on the bronze landing path
- D.A Databricks SQL alert on a query that counts the NULL rows, with a threshold condition, a 15-minute schedule and a Slack notification destination
Show answer and explanation
Correct answer: D. A Databricks SQL alert on a query that counts the NULL rows, with a threshold condition, a 15-minute schedule and a Slack notification destination
Why: Databricks SQL alerts run a query on a schedule, evaluate a condition on its result, and notify configured destinations such as email, Slack or webhooks when the condition is met. A NOT NULL constraint would reject the writes rather than count and report them, duration thresholds monitor how long jobs take, and file arrival triggers start jobs.
More free Databricks Data Engineer Professional questions
- Partitioning guidance for mid-size tables
- VACUUM retention duration safety check
- SQL warehouse sizing versus scaling
- BROWSE privilege for data discovery
- UNDROP TABLE for managed tables
- Workspace-catalog binding isolation
- Bundle generate and deployment bind
- Driver memory and toPandas
- Continuous job trigger for streaming
- Table update triggers for jobs
- Serverless environment dependencies