Implementing Data Engineering Solutions Using Microsoft Fabric — Question 41

You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1 outputs events to a table named Table1 in a lakehouse. The streaming data is sourced from motorway sensors and represents the speed of cars.

You need to add a transformation to EventStream1 to average the car speeds. The speeds must be grouped by non-overlapping and contiguous time intervals of one minute. Each event must belong to exactly one window.

Which windowing function should you use?

Answer options

• A. sliding
• B. hopping
• C. tumbling
• D. session

Correct answer: C

Explanation

The correct answer is C, tumbling, as it creates fixed-size, non-overlapping time windows, which is perfect for grouping events into one-minute intervals. Sliding and hopping windows allow for overlapping intervals, which does not meet the requirement of each event belonging to only one window. Session windows are based on activity and may not fit the strict time-based grouping needed in this scenario.