DP-203 Design and implement data storage Practice Question
You need to store streaming data from Azure Event Hubs into Azure Data Lake Storage Gen2 in near real-time. The data should be stored in Avro format with a folder structure: /raw/{eventhub}/{yyyy}/{MM}/{dd}/{HH}/{mm}. Which Azure service should you use to ingest the data?
⚠ Common exam trap
Many exam-takers choose Event Hubs Capture because it seems like a simple 'capture to storage' feature, but they overlook the requirement for near real-time per-minute partitioning, which Capture cannot achieve due to its fixed 5-minute minimum 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
✓
Azure Stream Analytics with a job that reads from Event Hubs and writes to ADLS Gen2.
Azure Stream Analytics is the correct choice because it natively supports reading from Event Hubs and writing to ADLS Gen2 with built-in time-based partitioning into the exact folder structure /raw/{eventhub}/{yyyy}/{MM}/{dd}/{HH}/{mm}. It provides near real-time processing with sub-minute latency and can output data in Avro format directly, meeting all requirements without additional code or orchestration.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Event Hubs Capture feature to automatically capture events to ADLS Gen2.
Why it's wrong here
Capture uses a predefined path pattern (e.g., {Namespace}/{EventHub}/{PartitionId}/{Year}/{Month}/{Day}/{Hour}/{Minute}), not the exact required pattern.
- ✓
Azure Stream Analytics with a job that reads from Event Hubs and writes to ADLS Gen2.
Why this is correct
Stream Analytics supports Avro output and custom partition path patterns.
- ✗
Azure Data Factory with a tumbling window trigger to copy data from Event Hubs every 5 minutes.
Why it's wrong here
ADF is not designed for near real-time streaming ingestion.
- ✗
Azure Databricks with Auto Loader to read from Event Hubs and write to ADLS Gen2.
Why it's wrong here
Auto Loader is for file ingestion, not for Event Hubs streaming.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DP-203 question from scratch — 760 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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.