CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #4
The data engineering team has configured a Databricks SQL query and alert to monitor the values in a Delta Lake table. The recent_sensor_recordings table contains an identifying sensor_id alongside th
The correct answer is E. The average temperature recordings for at least one sensor exceeded 120 on three consecutive. This is the correct answer because the query is using a GROUP BY clause on the sensor_id column, which means it will calculate the mean temperature for each sensor separately. The alert will trigger when the mean temperature for any sensor is greater than 120, which means at leas
Question
The data engineering team has configured a Databricks SQL query and alert to monitor the values in a Delta Lake table. The recent_sensor_recordings table contains an identifying sensor_id alongside the timestamp and temperature for the most recent 5 minutes of recordings. The below query is used to create the alert:
The query is set to refresh each minute and always completes in less than 10 seconds. The alert is set to trigger when mean (temperature) > 120. Notifications are triggered to be sent at most every 1 minute. If this alert raises notifications for 3 consecutive minutes and then stops, which statement must be true?
Options
- AThe total average temperature across all sensors exceeded 120 on three consecutive executions
- BThe recent_sensor_recordingstable was unresponsive for three consecutive runs of the query
- CThe source query failed to update properly for three consecutive minutes and then restarted
- DThe maximum temperature recording for at least one sensor exceeded 120 on three consecutive
- EThe average temperature recordings for at least one sensor exceeded 120 on three consecutive
How the community answered
(34 responses)- A6% (2)
- B3% (1)
- D12% (4)
- E79% (27)
Explanation
This is the correct answer because the query is using a GROUP BY clause on the sensor_id column, which means it will calculate the mean temperature for each sensor separately. The alert will trigger when the mean temperature for any sensor is greater than 120, which means at least one sensor had an average temperature above 120 for three consecutive minutes. The alert will stop when the mean temperature for all sensors drops below 120.
Topics
Community Discussion
No community discussion yet for this question.