Câu 29: Databricks Certified Data Engineer Professional

A junior data engineer has been asked to develop a streaming data pipeline with a grouped aggregation using DataFrame df. The pipeline needs to calculate the average humidity and average temperature for each non-overlapping five-minute interval. Events are recorded once per minute per device. Streaming DataFrame df has the following schema:"device_id INT, event_time TIMESTAMP, temp FLOAT, humidity FLOAT"Code block: Choose the response that correctly fills in the blank within the code block to complete this task.

1. A. to_interval("event_time", "5 minutes").alias("time")
2. B. window("event_time", "5 minutes").alias("time") — đáp án hiện tại
3. C. "event_time"
4. D. window("event_time", "10 minutes").alias("time")
5. E. lag("event_time", "10 minutes").alias("time")