Databricks Certified Data Engineer - Professional
Get started today
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?
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?
Explanation:
The alert is configured to monitor the average temperature across sensor readings, triggering when the mean temperature exceeds 120. Given the scenario where notifications are triggered for 3 consecutive minutes and then stop, it implies that the condition (mean temperature > 120) was met in each of those three consecutive query executions. Since the query is set to refresh each minute and completes in less than 10 seconds, the most plausible explanation is that the average temperature recordings for at least one sensor exceeded 120 on three consecutive executions of the query. This is because the alert would not trigger unless the specified condition was met, and the consecutive triggers indicate a sustained condition over those minutes. Options A, C, and D do not accurately describe the scenario based on the given information and the nature of the alert's configuration.