Ultimate access to all questions.
The data engineering team has set up a Databricks SQL query and alert to monitor a Delta Lake table named recent_sensor_recordings
, which includes sensor_id
, timestamp
, and temperature
for the latest 5 minutes of recordings.
The below query is used to create the alert:
SELECT MEAN(temperature), MAX(temperature), MIN(temperature)
FROM recent_sensor_recordings
GROUP BY sensor_id
The alert uses the following query (set to refresh every minute and complete in under 10 seconds) and triggers when mean(temperature) > 120
, with notifications sent at most once per minute.
If this alert fires notifications for 3 consecutive minutes and then stops, which statement must be true?