
Ultimate access to all questions.
A Databricks SQL query and alert are configured to monitor a Delta Lake table named sensor_recordings_table, which captures sensor IDs, timestamps, and temperatures for the most recent 5 minutes.
The query calculates the average, minimum, and maximum temperatures for each sensor and refreshes every minute (taking less than 10 seconds). The alert is set to trigger when the average temperature for any sensor exceeds 120 degrees, with notifications sent at most once per minute.
If this alert raises notifications for 3 consecutive minutes and then stops, which of the following statements must be true?
A
The overall average temperature across all sensors combined exceeded 120 degrees in three consecutive query executions.
B
The sensor_recordings_table was unavailable for three consecutive query runs.
C
The average temperature readings for at least one sensor were higher than 120 degrees in three consecutive query executions.
D
The maximum recorded temperature for at least one sensor exceeded 120 degrees in three consecutive query executions.
E
The source query failed to update its results for three minutes straight before restarting.