The correct choice is to use scheduled backups or asynchronous replication aligned to the RPO and RTO, because the workload’s 15-minute RPO and 4-hour RTO, combined with a cost-sensitive requirement that deprioritizes near-zero data loss, make synchronous multi-region replication unnecessarily expensive and latency-prone. This design leverages cost-effective database disaster recovery with backups—such as Azure SQL Database automated backups with point-in-time restore every 15 minutes—or asynchronous replication like active geo-replication, which can be tuned to meet the 15-minute RPO without the overhead of synchronous writes. On the AZ-305 exam, this scenario tests your ability to match recovery objectives to the right replication strategy, often appearing as a trap where candidates over-engineer with synchronous replication for modest RPOs. Remember the key trade-off: synchronous replication guarantees near-zero data loss but costs more, while backups or async replication are cheaper and sufficient when RPOs are minutes, not seconds. Memory tip: “Sync is for seconds, async for minutes—backups save your budget.”
AZ-305 Design business continuity solutions Practice Question
This AZ-305 practice question tests your understanding of design business continuity solutions. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. A key principle to apply: rPO defines the maximum acceptable data loss in a disaster.. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A database workload has an RPO of 15 minutes and an RTO of 4 hours. Cost is more important than near-zero data loss. Which design is usually more appropriate than synchronous multi-region replication?
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use scheduled backups or asynchronous replication aligned to the RPO/RTO.
Option A is correct because the workload's RPO of 15 minutes and RTO of 4 hours, combined with a cost-sensitive requirement that deprioritizes near-zero data loss, makes synchronous multi-region replication overkill. Scheduled backups (e.g., every 15 minutes using Azure SQL Database automated backups with point-in-time restore) or asynchronous replication (e.g., Azure SQL Database active geo-replication with a recovery point objective of up to 5 seconds, but here we can tune it to meet 15 minutes) provide sufficient protection at a lower cost, avoiding the latency and expense of synchronous replication across regions.
Key principle: RPO defines the maximum acceptable data loss in a disaster.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✓
Use scheduled backups or asynchronous replication aligned to the RPO/RTO.
Why this is correct
The requirement does not justify the cost and complexity of synchronous multi-region replication.
Related concept
RPO defines the maximum acceptable data loss in a disaster.
✗
Use synchronous replication across every Azure region.
Why it's wrong here
This is excessive and not aligned with the stated cost priority.
✗
Run the database on a single VM with no backups.
Why it's wrong here
This fails both the RPO and RTO requirements.
✗
Use a public DNS CNAME only.
Why it's wrong here
DNS alone does not protect or restore database state.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often assume synchronous replication is always the best choice for business continuity, but the question explicitly prioritizes cost over near-zero data loss, making asynchronous replication or scheduled backups the more appropriate and cost-effective design.
Detailed technical explanation
How to think about this question
Synchronous replication (e.g., SQL Server Always On Availability Groups with synchronous-commit mode) ensures zero data loss by requiring all replicas to acknowledge a transaction before it commits, but this introduces network latency proportional to the distance between regions (typically 50–100 ms round-trip), which can degrade write performance. Asynchronous replication (e.g., Azure SQL Database active geo-replication) uses a log-shipping mechanism where secondary databases are kept up to date with a lag of seconds to minutes, allowing a controlled RPO; for a 15-minute RPO, you can configure backup frequency or replication intervals accordingly. In a real-world scenario, a cost-conscious enterprise might use Azure SQL Database geo-restore from automated backups (which have a default retention of 7–35 days and a recovery point of up to 1 minute) or a custom backup strategy with Azure Backup for SQL Server on Azure VMs, achieving the required RPO without the expense of synchronous replication.
KKey Concepts to Remember
RPO defines the maximum acceptable data loss in a disaster.
RTO defines the maximum acceptable downtime after a disaster.
Asynchronous replication allows for some data loss but offers lower latency and cost.
Scheduled backups are a fundamental method for meeting RPO and RTO requirements.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
RPO defines the maximum acceptable data loss in a disaster.
Real-world example
How this comes up in practice
A startup's cloud architect reviews their monthly bill and notices costs are higher than expected for a long-running batch job. Switching from on-demand instances to Reserved Instances — or using Spot/Preemptible VMs — can reduce compute costs by up to 72 %. Questions like this test whether you understand the tradeoffs between commitment, flexibility, and cost across cloud pricing models.
Related glossary terms
Concepts from this question explained
These glossary pages explain the core terms tested in this AZ-305 question in full detail.
Design business continuity solutions — This question tests Design business continuity solutions — RPO defines the maximum acceptable data loss in a disaster..
What is the correct answer to this question?
The correct answer is: Use scheduled backups or asynchronous replication aligned to the RPO/RTO. — Option A is correct because the workload's RPO of 15 minutes and RTO of 4 hours, combined with a cost-sensitive requirement that deprioritizes near-zero data loss, makes synchronous multi-region replication overkill. Scheduled backups (e.g., every 15 minutes using Azure SQL Database automated backups with point-in-time restore) or asynchronous replication (e.g., Azure SQL Database active geo-replication with a recovery point objective of up to 5 seconds, but here we can tune it to meet 15 minutes) provide sufficient protection at a lower cost, avoiding the latency and expense of synchronous replication across regions.
What should I do if I get this AZ-305 question wrong?
Review rPO defines the maximum acceptable data loss in a disaster., then practise related AZ-305 questions on the same topic to reinforce the concept.
What is the key concept behind this question?
RPO defines the maximum acceptable data loss in a disaster.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.