DP-203 Design and implement data storage Practice Question
A multinational bank needs to store customer transaction records for 10 years to meet regulatory compliance. The data is rarely accessed after the first year. The solution must minimize storage costs while allowing queries on recent data with low latency. Which tiering strategy should you implement?
⚠ Common exam trap
Many candidates choose Option C thinking TTL in Cosmos DB can handle retention, but TTL deletes data automatically, which violates regulatory retention requirements, not just cost optimization.
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 Azure Blob Storage with lifecycle management to transition from Hot to Cool to Archive tiers
Azure Blob Storage lifecycle management automatically transitions blobs from Hot to Cool to Archive tiers based on age, minimizing storage costs for rarely accessed data after the first year while keeping recent data in Hot tier for low-latency queries. This aligns with the 10-year retention requirement and cost optimization goal without manual intervention.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Store all data in Azure SQL Database with partitioning and drop older partitions
Why it's wrong here
Azure SQL Database has no Archive tier; dropping partitions loses data permanently.
- ✗
Use Azure Data Lake Storage Gen2 with a single storage tier
Why it's wrong here
Data Lake Storage does not have Archive tier; lifecycle management requires Blob Storage.
- ✗
Store data in Azure Cosmos DB with time-to-live (TTL) and use Azure Blob Storage for backups
Why it's wrong here
Cosmos DB is expensive for long-term storage and TTL deletes data.
- ✓
Use Azure Blob Storage with lifecycle management to transition from Hot to Cool to Archive tiers
Why this is correct
Lifecycle management automates tier transitions, minimizing cost while retaining data.
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.