A facilities-monitoring team is building a near-real-time PowerBI dashboard off the Delta table device_readings: Columns: device_id (STRING, unique sensor ID) event_ts (TIMESTAMP, ingestion timestamp UTC) temperature_c (DOUBLE, temperature in °C) Requirement: For each sensor, generate one row per non-overlapping 5-minute interval, offset by 2 minutes (e.g., 00:02-00:07, 00:07-00:12, ...). Each row must include interval start, interval end, and average temperature in that slice. Downstream BI tools (e.g., Power BI) must use the interval timestamps to plot time-series bars.
Select one answer.
Purchase Full Access to view answer options & explanation
The first 119 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 395 questions.
