DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

You have a Fabric workspace containing an eventstream named EventStream1. EventStream1 sends events to a table named Table1 in a lakehouse. The streaming data comes from motorway sensors and represents car speeds.

You need to add a transformation to EventStream1 that averages the car speeds. The speeds must be grouped into one-minute, non-overlapping, contiguous time intervals. Every event must belong to exactly one window.

Which windowing function should you use?