DP-203 Develop data processing Practice Question
You are implementing a real-time analytics solution using Azure Stream Analytics. The job ingests data from Azure Event Hubs and must output to an Azure SQL Database. You need to ensure that the job can handle out-of-order events and produce accurate aggregations over 5-minute windows. Which setting should you configure?
⚠ Common exam trap
The trap here is mixing up out-of-order tolerance with late arrival tolerance, and choosing overlapping or dynamic windows instead of the fixed Tumbling Window.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Set the 'Out-of-order tolerance' to 5 minutes and use a Tumbling Window of 5 minutes.
To handle out-of-order events and aggregate over fixed 5-minute windows, configure the out-of-order tolerance to 5 minutes and use a Tumbling Window. The tolerance allows late events to be processed, and the Tumbling Window provides non-overlapping, fixed-duration aggregations. Other window types or settings do not meet both requirements simultaneously.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Set the 'Late arrival tolerance' to 5 minutes and use a Sliding Window of 5 minutes.
Why it's wrong here
Late arrival tolerance adjusts the watermark but does not directly control out-of-order events. A Sliding Window triggers when events occur, not on fixed intervals, which may not align with the 5-minute aggregation requirement. This approach does not guarantee accurate fixed-window aggregations.
- ✗
Set the 'Event ordering' to 'Adjust' and use a Session Window with a 5-minute timeout.
Why it's wrong here
Event ordering 'Adjust' reorders events but does not specify a tolerance. A Session Window groups events based on inactivity, not fixed time windows. This would not produce aggregations over exact 5-minute intervals and thus fails the requirement.
- ✗
Set the 'Out-of-order tolerance' to 0 and use a Hopping Window of 5 minutes with a 1-minute hop.
Why it's wrong here
With zero out-of-order tolerance, late events are dropped, leading to inaccurate aggregations. A Hopping Window with a 1-minute hop creates overlapping windows, which may not be desired for simple 5-minute aggregations. This configuration does not handle out-of-order events as required.
- ✓
Set the 'Out-of-order tolerance' to 5 minutes and use a Tumbling Window of 5 minutes.
Why this is correct
The out-of-order tolerance allows events to be accepted up to 5 minutes late, and a Tumbling Window aggregates events into non-overlapping 5-minute intervals. This combination ensures that late events are included in the correct window, producing accurate aggregations.
Go deeper
Related to this question
About these practice questions
One of 509 original DP-203 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This DP-203 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-203 exam.