CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #4
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
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
Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.