20+ practice questions focused on Plan and configure high availability and disaster recovery — one of the most tested topics on the Microsoft Azure Database Administrator Associate DP-300 exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Plan and configure high availability and disaster recovery PracticeA company runs a critical Azure SQL Database in the West US region. To meet a Recovery Point Objective (RPO) of 5 seconds and a Recovery Time Objective (RTO) of 30 seconds during a regional outage, which deployment option should be used?
Explanation: For a regional outage, you need a secondary in a different Azure region. Auto-Failover Groups provide automatic failover with a configurable data loss threshold. The RPO of 5 seconds can be achieved by setting the grace period appropriately, and automatic failover can typically occur within seconds to meet the RTO of 30 seconds. The Business Critical tier with zone-redundant configuration only protects against availability zone failures within the same region, not a full regional outage. Other options either have longer RTO (point-in-time restore) or require manual failover (Active Geo-Replication with readable secondary without automatic failover).
You are the database administrator for a global e-commerce company. The company runs its production SQL Server on an Azure Virtual Machine (IaaS) in the West US region. The database is mission-critical and requires a Recovery Point Objective (RPO) of 5 minutes and a Recovery Time Objective (RTO) of 30 minutes in the event of a regional disaster. The VM uses premium SSDs and is backed up daily to a Recovery Services vault with geo-redundant storage. The current backup policy takes full backups weekly, differential backups daily, and transaction log backups every 15 minutes. The VM is in an availability set for high availability within the region. During a recent regional outage simulation, the database was unavailable for 4 hours because the backups needed to be restored to a different region, and the restore process took longer than expected. You need to recommend a solution to meet the RPO and RTO requirements. What should you do?
Explanation: A SQL Server Always On availability group with a synchronous-commit replica in a secondary Azure region provides automatic failover with zero data loss (RPO of 0 seconds) and can meet the 30-minute RTO by enabling fast, automated failover to the secondary region. This solution eliminates the need for manual restore processes and ensures continuous data synchronization, directly addressing the 4-hour outage caused by slow geo-restore.
Refer to the exhibit. An administrator creates a geo-replica for SalesDB. After 30 minutes, the replication state remains SEEDING. What is the most likely cause?
Explanation: Geo-replication seeds the database by copying data from primary to secondary. Being in a different region introduces network latency and higher transfer time, which can cause the SEEDING state to persist for an extended period. Zone redundancy is not a prerequisite for geo-replication.
A company has an Azure SQL Managed Instance in the East US region. They need to implement disaster recovery with automatic failover to a paired region. The solution must minimize data loss to less than 5 seconds. Which feature should they use?
Explanation: Auto-Failover Groups for Azure SQL Managed Instance provide automatic failover to a paired region (West US) with a replication lag target of less than 5 seconds when using the Readable Secondary option. This feature uses synchronous replication at the commit level to minimize data loss, meeting the RPO requirement of <5 seconds.
A company runs SQL Server 2019 on Azure Virtual Machines in an availability set. They need to achieve high availability for a critical database with automatic failover and no shared storage. The solution must minimize downtime during planned maintenance. What should they implement?
Explanation: An Always On Availability Group (AG) with a listener provides high availability with automatic failover at the database level without requiring shared storage. This solution meets the requirement for automatic failover and minimizes downtime during planned maintenance by allowing manual failover to a synchronized secondary replica with minimal disruption.
+15 more Plan and configure high availability and disaster recovery questions available
Practice all Plan and configure high availability and disaster recovery questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Plan and configure high availability and disaster recovery. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Plan and configure high availability and disaster recovery questions on the DP-300 frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Plan and configure high availability and disaster recovery is tested as part of the Microsoft Azure Database Administrator Associate DP-300 blueprint. Practicing with targeted Plan and configure high availability and disaster recovery questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free DP-300 practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Plan and configure high availability and disaster recovery is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Plan and configure high availability and disaster recovery practice session with instant scoring and detailed explanations.
Start Plan and configure high availability and disaster recovery Practice →