hardMultiple ChoiceObjective-mapped
DP-203 Partition scheme for Stream Analytics Practice Question
You are building a streaming pipeline in Azure Stream Analytics that reads from an Azure Event Hubs input with 10 partitions. The query performs a GROUP BY on a column that is not the partition key. To ensure consistency, which partitioning scheme should you use?
⚠ Common exam trap
Many exam-takers confuse 'Passthrough' partitioning with automatic handling of GROUP BY, or they think increasing SUs can fix data skew, but the core requirement is explicit repartitioning via PARTITION BY to align the data with the grouping key.
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 'PartitionBy' with the GROUP BY column
When performing a GROUP BY on a column that is not the partition key, you must use the PARTITION BY clause in the query to ensure that all rows with the same grouping value are processed by the same Stream Analytics node. This guarantees consistency and correctness of the aggregation, as it avoids data being split across multiple nodes without proper alignment.
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 'Passthrough' partitioning
Why it's wrong here
Passthrough keeps the original partition scheme, which may not align with the GROUP BY column.
- ✗
Increase the number of SUs to handle skew
Why it's wrong here
Scaling SUs does not fix partitioning alignment issues.
- ✗
Use 'INTO' with a 'PARTITION BY' clause
Why it's wrong here
INTO is for output, not for repartitioning within the query.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-203 exam frequently reuses these exact scenarios with slightly different constraints.
✓Use 'PartitionBy' with the GROUP BY columnCorrect answer▾
✗Use 'Passthrough' partitioningWrong answer — click to see why▾
Why this is wrong here
Passthrough keeps the original partition scheme, which may not align with the GROUP BY column.
✗Increase the number of SUs to handle skewWrong answer — click to see why▾
Why this is wrong here
Scaling SUs does not fix partitioning alignment issues.
✗Use 'INTO' with a 'PARTITION BY' clauseWrong answer — click to see why▾
Why this is wrong here
INTO is for output, not for repartitioning within the query.
Analysis generated from the official DP-203blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Go deeper
Related to this question
About these practice questions
One of 760 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 by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.