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).
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 uses Azure SQL Database Hyperscale tier for a large database. They need to perform a disaster recovery drill by failing over to a secondary region with minimal data loss. The secondary is in a paired region and is readable. Which approach should they use?
Explanation: Auto-Failover Groups with Azure SQL Database Hyperscale provide automated, orchestrated failover to a secondary region with minimal data loss by using synchronous replication for the log service. This meets the requirement for a disaster recovery drill with a readable secondary and minimal data loss, as the secondary is kept in sync and can be failed over manually or automatically.
Which THREE factors should be considered when choosing between Azure SQL Database active geo-replication and auto-failover groups for disaster recovery?
Explanation: Option A (Automatic failover capability) is correct because auto-failover groups provide automatic failover of the entire group when the primary region becomes unavailable, whereas active geo-replication requires manual failover initiation, making this a key differentiator when choosing between the two. Option C (Number of readable secondary replicas required) is correct because active geo-replication supports up to four readable secondaries per primary database, while auto-failover groups support only one readable secondary per group, so the required number of readable replicas directly influences the choice. Option E (Granular control over individual database failover) is correct because active geo-replication allows failover at the individual database level, while auto-failover groups fail over all databases in the group together, so the need for per-database granularity is a deciding factor. Option B is not a differentiator because both features provide an RPO of approximately 5 seconds (not 1 second), and Option D is not a distinguishing factor because both active geo-replication and auto-failover groups support SQL Server Authentication.
You are troubleshooting an Always On Availability Group named AG1. The exhibit shows the current state. The primary replica shows PENDING_FAILOVER. The secondary replica is DISCONNECTED with error 35202. What is the most likely cause of this issue?
Explanation: The PENDING_FAILOVER state on the primary replica indicates that a failover was initiated but could not complete because the secondary replica is DISCONNECTED. Error 35202 specifically indicates that a connection attempt to the secondary replica failed, which in an Always On Availability Group (AG) is typically due to a network connectivity issue on the dedicated endpoint port (default 5022). Since the secondary is unreachable, the failover cannot finalize, leaving the primary in a pending state.
+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 →