Answer-first summary for fast verification
Answer: The average temperature readings for at least one sensor were higher than 120 degrees in three consecutive query executions.
The alert is configured to trigger based on the **average temperature** of **any** individual sensor. * **Why C is correct:** Databricks SQL alerts evaluate the results of the underlying query. If a notification is sent, it means the condition (average > 120) was met during that specific evaluation. Receiving notifications for three consecutive minutes confirms that in each of those three distinct one-minute intervals, at least one sensor met the threshold. * **Why A is incorrect:** The alert is per-sensor, not a global average across the entire fleet. * **Why B and E are incorrect:** If the table were unavailable or the query failed to update, the alert would typically transition to an `UNKNOWN` or `ERROR` state rather than firing a success notification. * **Why D is incorrect:** While a high maximum often accompanies a high average, the alert is specifically monitoring the average. It is theoretically possible for a maximum to exceed 120 while the average stays below 120, in which case the alert would not fire.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.