DP-203 Certification Practice Question #99

Question

You are processing streaming data from vehicles that pass through a toll booth.
You need to use Azure Stream Analytics to return the license plate, vehicle make, and hour the last vehicle passed during each 10-minute window.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

Microsoft Learn’s canonical pattern for returning the last event in a fixed window computes `MAX(Time)` inside a tumbling window, then joins the original stream back to that derived rowset using `DATEDIFF` and the matching timestamp. That exactly fits the exhibit and the requirement to return the last vehicle in each non-overlapping 10-minute interval. The community comments overwhelmingly reinforce the same pattern.

More DP-203 practice questions