DP-300 Plan and implement data platform resources Practice Question
You are a database administrator for a company that uses Azure SQL Database. The company wants to reduce the cost of storing backups. You need to configure the backup storage redundancy to the most cost-effective option while ensuring data durability within a single region. What should you do?
⚠ Common exam trap
The trap here is assuming that higher redundancy always means better, without considering the cost requirement and the need for only single-region durability.
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
✓
Configure locally redundant backup storage.
Locally redundant backup storage is the most cost-effective option that provides durability within a single region. It replicates backups three times within the same region, ensuring data redundancy without the added cost of cross-region replication. Geo-redundant and zone-redundant options offer higher durability but at a higher price.
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 zone-redundant backup storage.
Why it's wrong here
Zone-redundant backup storage replicates backups across multiple availability zones within a region, offering higher durability than locally redundant storage. However, it is more expensive. Since the goal is to minimize cost while ensuring single-region durability, this option exceeds the requirement and is not the most cost-effective.
- ✗
Configure geo-redundant backup storage.
Why it's wrong here
Geo-redundant backup storage replicates backups to a secondary region, providing higher durability and protection against regional failures. However, it is more expensive than locally redundant storage. Since the requirement is to minimize cost while ensuring durability within a single region, this option is not the most cost-effective.
- ✓
Configure locally redundant backup storage.
Why this is correct
Locally redundant backup storage replicates backups three times within a single region, providing durability within that region at a lower cost than geo-redundant or zone-redundant options. This meets the requirement for cost-effectiveness and single-region durability. It is the default and most economical choice for backup storage redundancy.
- ✗
Configure read-access geo-redundant backup storage.
Why it's wrong here
Read-access geo-redundant storage replicates backups to a secondary region and allows read access to the secondary. It provides the highest durability but is the most expensive option. It is not cost-effective for the stated requirement, which only needs single-region durability.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
One of 574 original DP-300 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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This DP-300 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-300 exam.