Certified Data Engineer Professional Exam QuestionsBrowse all questions from this exam

Certified Data Engineer Professional Exam - 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 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?

Show Answer
Correct Answer: E

The alert is set to trigger when the mean temperature exceeds 120. Given that notifications were raised for three consecutive minutes and then stopped, it must be true that the average temperature recordings for at least one sensor exceeded 120 on three consecutive executions of the query.

Discussion

5 comments
Sign in to comment
sturcuOption: E
Oct 11, 2023

correct

saikotOption: E
Sep 30, 2023

The correct answer is E https://www.myexamcollection.com/databricks-certified-professional-data-engineer-databricks-certified-professional-data-engineer-exam-question-answers.htm

Jay_98_11Option: E
Jan 13, 2024

E is correct

imatheushenriqueOption: E
Jun 5, 2024

E. The average temperature recordings for at least one sensor exceeded 120 on three consecutive executions of the query

panya
Jun 24, 2024

Correct