🔥 3-day streak
Microsoft Fabric Data Engineer Associate57 / 144
Question 57 of 144

You store IoT telemetry in an Eventhouse (KQL database) table called DeviceReadings, which contains columns Timestamp (datetime), DeviceId (string), and Temperature (real). A real-time dashboard must display the average temperature per device for each fixed, non-overlapping one-hour interval. Which KQL query correctly produces these hourly aggregates?

Reviewed for accuracy · Report an issueNext question