20+ practice questions focused on Plan and configure a high availability and disaster recovery environment — 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 a high availability and disaster recovery environment PracticeYour company has an Azure SQL Database in the General Purpose tier. You need to reduce the recovery point objective (RPO) from 1 hour to less than 1 minute for disaster recovery. Which action should you take?
Explanation: None of the listed options reduce the geo-replication RPO to under 1 minute. Upgrading to Business Critical (B) improves local HA with synchronous replicas but does not affect geo-replication, which remains asynchronous with an RPO of about 1 hour. Enabling zone redundancy (C) protects against zone failures, not regional disasters. Increasing backup retention (A) or DTU/vCore (D) does not change replication mode. To achieve sub-minute RPO for geo-disaster recovery, you must configure Active Geo-Replication or a failover group, which are not among the options.
You have an Azure SQL Managed Instance in the East US region. To meet a 1-hour RPO and 2-hour RTO, you configure a failover group with a secondary in West US using automatic failover. During a test, you notice that the RTO is consistently 10 minutes longer than required. What is the most likely cause?
Explanation: The failover group's automatic failover includes a grace period (default 20 minutes) that delays the actual failover after detecting unavailability. This grace period directly contributes to the RTO, explaining the 10-minute exceedance of the required 2-hour RTO. Option A is incorrect because Microsoft Entra ID authentication does not add noticeable latency to the failover process; authentication occurs independently of replication and failover. Option B is incorrect because asynchronous commit is the standard replication mode for failover groups and does not inherently cause additional delay beyond the grace period; the issue is not the commit mode but the waiting period before failover. Option D is incorrect because the secondary database is automatically seeded when the failover group is created; no manual restore is needed.
You have an Azure SQL Database in the Business Critical tier without zone redundancy. You need to configure a disaster recovery plan that ensures the database is available in a different Azure region within 1 hour of a regional outage. The solution must minimize data loss and not require manual intervention. What should you do?
Explanation: Active geo-replication provides asynchronous replication to a secondary region, and auto-failover groups enable automatic failover without manual intervention, meeting the RTO of 1 hour with minimal data loss. Option B is incorrect because simply creating a failover group does not guarantee automatic failover; the failover policy must be set to automatic, which is explicitly included in option A. Also, active geo-replication must be configured before setting up the failover group for single databases. Option C (geo-restore) has a longer RTO and potential data loss. Option D (copy-only backups) is not a disaster recovery solution.
You manage an Azure SQL Database that uses the General Purpose tier. The database has a failover group with a secondary in a paired region. During a regional outage, you initiate a forced failover. After the outage is resolved, you want to bring the original primary region back online without data loss. What should you do?
Explanation: After a forced failover, the original primary becomes a secondary and automatically synchronizes data when the region recovers. Once synchronization completes, initiating another forced failover from the new primary to the old primary (option A) switches roles without data loss because all transactions are committed and data is consistent. A planned failover (option C) is designed for graceful, non-emergency role changes when the primary is online and can be intentionally demoted; however, in this scenario, after a forced failover, the system expects a forced failover to reverse roles. Attempting a planned failover would not be valid because the old primary may not be in the correct state for a planned operation. Options B and D are incorrect: option B repeats an unspecified failover, and option D would cause data loss.
You manage an Azure SQL Database in the East US region. The database uses the General Purpose service tier with geo-redundant backup storage. You need to ensure that in the event of a regional outage, you can restore the database to the West US region with the least possible downtime. What should you use?
Explanation: Geo-restore from geo-redundant backups allows restoring to a different region, meeting the requirement with minimal downtime. Option A is wrong because active geo-replication is not configured by default and would require manual setup, which is not the least possible downtime. Option C is wrong because creating a copy-only backup and manually transferring it to West US is time-consuming and not automated. Option D is wrong because a point-in-time restore can only restore to a new database within the same region, not to a different region.
+15 more Plan and configure a high availability and disaster recovery environment questions available
Practice all Plan and configure a high availability and disaster recovery environment questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Plan and configure a high availability and disaster recovery environment. 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 a high availability and disaster recovery environment 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 a high availability and disaster recovery environment is tested as part of the Microsoft Azure Database Administrator Associate DP-300 blueprint. Practicing with targeted Plan and configure a high availability and disaster recovery environment 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 a high availability and disaster recovery environment 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 a high availability and disaster recovery environment practice session with instant scoring and detailed explanations.
Start Plan and configure a high availability and disaster recovery environment Practice →