Question 581 of 760
DP-203 Develop data processing Practice Question
You are implementing a streaming solution using Azure Stream Analytics. The input is from an IoT Hub receiving telemetry from thousands of devices. The output is to Azure Synapse Analytics dedicated SQL pool. The requirement is to compute rolling averages over a 5-minute tumbling window and write results every minute. Which windowing function and output configuration should you use?
⚠ Common exam trap
Many candidates confuse the output frequency with the window duration, assuming a TumblingWindow can produce results more frequently by adjusting the duration, but only a HoppingWindow with a hop smaller than the size can achieve that.
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
✓
Use a HoppingWindow with size 5 minutes and hop 1 minute.
A HoppingWindow with a size of 5 minutes and a hop of 1 minute allows you to compute rolling averages over a 5-minute window while producing results every minute. This satisfies the requirement of outputting results at a higher frequency than the window duration, which is not possible with a TumblingWindow (which only outputs at the end of the window) or a SlidingWindow (which outputs on each event, not at fixed intervals).
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a TumblingWindow with duration of 5 minutes and output every 5 minutes.
Why it's wrong here
Tumbling windows output only at the end of each 5-minute window, not every minute.
- ✗
Use a SlidingWindow with duration 5 minutes and output every 1 minute.
Why it's wrong here
Sliding windows are event-driven and output for each event, not on a fixed schedule.
- ✓
Use a HoppingWindow with size 5 minutes and hop 1 minute.
Why this is correct
Hopping windows with a 1-minute hop produce results every minute, each covering the last 5 minutes.
- ✗
Use a SessionWindow with timeout 5 minutes and maximum duration 10 minutes.
Why it's wrong here
Session windows are based on gaps in data, not suitable for fixed-interval rolling averages.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 24, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.