AZ-305 Design infrastructure solutions Practice Question
You are designing a backup and disaster recovery strategy for an Azure SQL Database instance that runs a critical business application. The database is 500 GB and experiences high transaction rates. The recovery point objective (RPO) is 1 minute and recovery time objective (RTO) is 1 hour. What should you recommend?
⚠ Common exam trap
Many candidates confuse geo-redundant backup storage (which provides backup redundancy but not real-time replication) with active geo-replication (which provides near-real-time data synchronization for DR), leading them to choose Option A despite its insufficient RPO.
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 active geo-replication to a secondary region in the same Azure geography.
Active geo-replication for Azure SQL Database provides a continuously synchronized readable secondary replica in a different Azure region, enabling failover with an RPO of 1 minute (due to synchronous replication) and an RTO of 1 hour (since failover is manual or can be automated). This meets the critical business application's requirements for high transaction rates and low data loss.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable geo-redundant backup storage and use geo-restore in the secondary region.
Why it's wrong here
Geo-redundant backup storage relies on Azure's automated backup replication to the paired region, but geo-restore is a point-in-time backup operation with an RPO of up to 1 hour and an RTO typically ranging from 2 to 12 hours. Because the backups are taken periodically and the secondary copy is updated asynchronously, you cannot recover to the most recent transaction with low latency. This option fails your requirement of a 1-minute RPO and minutes-level RTO, and is therefore unsuitable for a proactive disaster-recovery plan.
- ✗
Configure automated backups with locally-redundant storage (LRS) and enable point-in-time restore.
Why it's wrong here
Automated backups with LRS and point-in-time restore provide a granular RPO of 5–10 minutes, but they are stored only in the primary region and are not available for recovery if that entire region becomes unavailable. Restoring a database from these backups creates a new database and copies data back, so the RTO depends on database size and can easily exceed an hour. Since you need sub-minute data loss and fast failover under regional failure, this single-region backup approach does not meet the requirement.
- ✓
Configure active geo-replication to a secondary region in the same Azure geography.
Why this is correct
Active geo-replication continuously replicates transactions from a primary database to one or more readable secondary databases in a paired or chosen secondary region, achieving an RPO of typically 5 seconds and an RTO of under 1 minute when paired with automatic failover groups. Because the secondary is always online and kept nearly synchronized, a failover merely changes the role and does not require copying or restoring data. This is the only option that satisfies both the aggressive 1-minute RPO and the minutes-level RTO while also providing cross-region redundancy.
- ✗
Export the database to a bacpac file daily and store it in Azure Blob Storage.
Why it's wrong here
Exporting the database to a bacpac file on a daily schedule generates a single point-in-time snapshot, so you can lose up to 24 hours of transactions—far exceeding your 1-minute RPO. Restoring that bacpac requires importing it through the database import service, which is a costly, slow operation that can take hours depending on size and throughput. Bacpac exports are intended for migration or archival, not for disaster recovery where near-zero data loss and rapid failover are mandatory.
Go deeper
Related to this question
Learn chapter
Data Residency and Sovereignty Requirements
Key term
BIA and RPO RTO Design
Business Impact Analysis and the design of Recovery Point Objective and Recovery Time Objective define how much data loss and downtime a business can tolerate after an IT failure, guiding the architecture of backup and disaster recovery systems.
Key term
Azure Site Recovery
Azure Site Recovery is a Microsoft Azure service that keeps your business applications and data running by automatically replicating them to a secondary location and failing over if the primary site goes down.
About these practice questions
One of 795 original AZ-305 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 AZ-305 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 AZ-305 exam.