hardMultiple SelectObjective-mapped
DP-203 Practice Question: Stream Analytics static reference data…
You are designing a stream processing solution using Azure Stream Analytics. The job must reference a static lookup table (product catalog) stored in Azure Blob Storage. The catalog is updated once daily. The job should automatically pick up the latest version without restarting. Which two configurations are required? (Choose two.)
⚠ Common exam trap
Candidates often think a static path or Event Grid restart is needed, but the question specifically tests the combination of dynamic path patterns and automatic refresh to achieve zero-downtime updates in Azure Stream Analytics.
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 reference input's 'Path pattern' to include date and time placeholders
Azure Stream Analytics reference data inputs support path pattern placeholders like {date} and {time} to dynamically resolve the latest blob file. This allows the job to automatically load a new version of the static lookup table when the blob is updated, without requiring a job restart. The path pattern must be structured to match the naming convention of the uploaded file, such as 'catalog/{date}/{time}/products.csv'.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Configure the reference input with a static blob path
Why it's wrong here
Static path does not trigger auto-refresh; you need a pattern to detect new blobs.
- ✗
Use Azure Event Grid to trigger job restart on blob update
Why it's wrong here
Restarting the job is not required; auto-refresh avoids restart.
- ✗
Store the reference data in Azure SQL Database instead of Blob Storage
Why it's wrong here
While SQL Database is an option, the question specifies Blob Storage; auto-refresh works with Blob Storage.
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.
✓Set the reference input's 'Path pattern' to include date and time placeholdersCorrect answer▾
✗Configure the reference input with a static blob pathWrong answer — click to see why▾
Why this is wrong here
Static path does not trigger auto-refresh; you need a pattern to detect new blobs.
✗Use Azure Event Grid to trigger job restart on blob updateWrong answer — click to see why▾
Why this is wrong here
Restarting the job is not required; auto-refresh avoids restart.
✗Store the reference data in Azure SQL Database instead of Blob StorageWrong answer — click to see why▾
Why this is wrong here
While SQL Database is an option, the question specifies Blob Storage; auto-refresh works with Blob Storage.
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?”
Visual reference
Quick reference
Azure Blob Storage Tier Comparison
| Tier | Storage Cost | Retrieval Cost | Latency | Use Case |
|---|---|---|---|---|
| Hot | Highest | Lowest | Immediate | Active data, frequent reads |
| Cool | Lower | Higher | Immediate | Data accessed < once / month |
| Cold | Lower still | Higher | Immediate | Data accessed < once / quarter |
| Archive | Lowest | Highest + rehydration delay | Hours | Long-term compliance retention |
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.