Courseiva

DP-300 · topic practice

Plan and configure a high availability and disaster recovery environment practice questions

This domain covers designing and configuring resilience for Azure SQL Database, SQL Managed Instance, and SQL Server on Azure VMs. You must choose between auto-failover groups, active geo-replication, and Azure Site Recovery, then configure readable secondaries, failover policies, grace periods, and validate recovery during drills.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Editorial oversight:Johnson Ajibi· MSc IT Security, IEEE Senior Member
20 questionsDomain: Plan and configure a high availability and disaster recovery environment
Practice 10 questionsBrowse domain →

What the exam tests

What to know about Plan and configure a high availability and disaster recovery environment

You must be able to pick the right HA/DR service per platform and configure failover groups, geo-replication, or Always On with correct readable secondary and failover policy settings. The most important thing: know which option gives automated failover with a readable, backup-capable secondary.

Configuring auto-failover groups for Azure SQL Database and SQL Managed Instance across regions

Selecting active geo-replication versus failover groups for readable secondaries and backup support

Setting readWriteEndpoint automatic failover policy and grace period in ARM templates

Using Azure Site Recovery and Always On availability groups for SQL Server on Azure VMs

Watch out for

Common Plan and configure a high availability and disaster recovery environment exam traps

  • ▸Assuming a geo-secondary is readable or supports backups by default; some replication options are non-readable and cannot serve read workloads.
  • ▸Forgetting that automatic failover requires a grace period and that failover group endpoints change connection strings after failover.
  • ▸Treating Azure Site Recovery as application-consistent for SQL Server without configuring crash-consistent versus app-consistent snapshots and Always On.

Practice set

Plan and configure a high availability and disaster recovery environment questions

20 questions · select your answer, then reveal the explanation

Question 1mediummultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

Your company runs a mission-critical application on Azure SQL Database in the East US region. You need to ensure automatic failover with zero data loss in case of a regional outage. Which deployment option should you use?

Question 2easymultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

You have an Azure SQL Database in the Business Critical tier with a failover group to a secondary region. The primary region experiences a full outage. What is the expected recovery time objective (RTO) and recovery point objective (RPO) if you initiate a manual failover?

Question 3mediummultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

Your company uses Azure SQL Database Hyperscale tier for a large data warehouse. You need to implement disaster recovery with the ability to perform point-in-time restore in the secondary region. What is the best approach?

Question 4easymultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

You are designing a high availability solution for an Azure SQL Database used by a critical application. The application requires no more than 5 seconds of data loss and automatic failover within 1 minute. Which service tier and configuration should you choose?

Question 5hardmultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

You have a SQL Server on Azure Virtual Machine running a critical OLTP workload. You need to achieve high availability with automatic failover and no shared storage. The solution must use Azure features and avoid complex clustering configurations. What should you implement?

Question 6easymultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

You need to ensure that an Azure SQL Managed Instance remains available in the event of a single availability zone failure in a region that supports availability zones. What should you configure?

Question 7hardmultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

Your company uses Azure SQL Database with active geo-replication for disaster recovery. During a drill, you need to verify that the secondary database is ready for failover and that data synchronization is current. Which query should you run on the secondary database?

Question 8mediummulti select
Read the full Plan and configure a high availability and disaster recovery environment explanation →

Which TWO actions should you take to minimize downtime during a planned failover of an Azure SQL Database failover group? (Choose two.)

Question 9mediummultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

You are deploying an Azure SQL Database with the above ARM template snippet. How many readable replicas will be available for read-only queries?

Exhibit

Refer to the exhibit.

```
{
  "sku": {
    "name": "BusinessCritical",
    "tier": "BusinessCritical",
    "family": "Gen5",
    "capacity": 8
  },
  "properties": {
    "zoneRedundant": true,
    "highAvailabilityReplicaCount": 2,
    "readScale": "Enabled"
  }
}
```
Question 10mediummultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

You are examining the configuration of an Azure SQL Database in the Business Critical tier. The exhibit shows the database properties. What is the maximum number of readable replicas available for read-only queries?

Exhibit

Refer to the exhibit.

```
{
  "properties": {
    "readScale": "Enabled",
    "zoneRedundant": false,
    "highAvailabilityReplicaCount": 4,
    "requestedServiceObjectiveName": "BC_Gen5_8"
  }
}
```
Question 11mediummultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

Your company has an Azure SQL Database with active geo-replication to a secondary region. During a regional outage, the secondary database becomes the primary. After the outage is resolved, you need to bring the original primary back online with minimal data loss and without creating a new secondary. What should you do?

Question 12mediummultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

You have an Azure SQL Managed Instance configured with a failover group across two regions. The primary region experiences a complete outage. You perform a manual failover to the secondary region. After the primary region is restored, you need to bring the original primary back into the failover group. What is the correct order of actions?

Question 13hardmultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

Your company uses Azure SQL Database with active geo-replication. You need to ensure that in the event of a regional disaster, the failover to the secondary region occurs automatically with minimal downtime. The secondary region must be in a different Azure geography for compliance. What should you configure?

Question 14easymultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

You are designing a disaster recovery plan for an Azure SQL Database that stores critical financial data. The RPO must be 5 seconds, and the RTO must be 30 seconds. Which solution should you recommend?

Question 15hardmultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

Your company has an Azure SQL Database configured with active geo-replication to a secondary region. You need to perform a planned failover for disaster recovery testing with zero data loss. The primary database is under heavy write load. What should you do?

Question 16easymultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

You have Azure SQL Database elastic pools in the primary region. You need to configure disaster recovery using a failover group. The secondary pool must be in a different region. Which PowerShell cmdlet should you use to create the secondary pool?

Question 17hardmulti select
Read the full Plan and configure a high availability and disaster recovery environment explanation →

Which THREE of the following are required considerations when configuring a failover group for Azure SQL Managed Instance?

Question 18easymulti select
Read the full Plan and configure a high availability and disaster recovery environment explanation →

Which TWO of the following are valid disaster recovery options for Azure SQL Database that provide a secondary in a different Azure region?

Question 19mediummultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

Your company has an Azure SQL Managed Instance in the West US region. You need to configure a disaster recovery solution that provides automatic failover to a secondary region with minimal data loss. The solution must also allow read-only access to the secondary database for reporting purposes. Which option should you use?

Question 20hardmultiple choice
Read the full Plan and configure a high availability and disaster recovery environment explanation →

You have an Azure SQL Database configured with active geo-replication to a secondary region. A regional outage occurs in the primary region. You need to manually fail over to the secondary database with the least amount of data loss. Which PowerShell cmdlet should you run?

Continue with 20-question session →

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Sign up freeLog in

Focused Plan and configure a high availability and disaster recovery environment sessions

Start a Plan and configure a high availability and disaster recovery environment only practice session

Every question in these sessions is drawn from the Plan and configure a high availability and disaster recovery environment domain — nothing else.

10 questions20 questions30 questions50 questions
Browse all Plan and configure a high availability and disaster recovery environment questions →Mixed DP-300 session

Related practice questions

Related DP-300 topic practice pages

Move into related areas when this topic feels solid.

Configure and manage automation of tasks practice questions

Work through DP-300 questions on Configure and manage automation of tasks.

Plan and configure high availability and disaster recovery practice questions

Plan and configure high availability and disaster recovery practice questions for DP-300.

Implement a secure environment practice questions

Sharpen your DP-300 knowledge of Implement a secure environment.

Plan and configure a high availability and disaster recovery environment practice questions

Targeted DP-300 practice covering Plan and configure a high availability and disaster recovery environment.

Plan and implement data platform resources practice questions

Targeted DP-300 practice covering Plan and implement data platform resources.

Monitor, configure, and optimize database resources practice questions

Monitor, configure, and optimize database resources practice questions for DP-300.

DP-300 fundamentals practice questions

Targeted DP-300 practice covering DP-300 fundamentals.

DP-300 scenario practice questions

Work through DP-300 questions on DP-300 scenario.

DP-300 troubleshooting practice questions

Targeted DP-300 practice covering DP-300 troubleshooting.

Frequently asked questions

What does the DP-300 exam test about Plan and configure a high availability and disaster recovery environment?
You must be able to pick the right HA/DR service per platform and configure failover groups, geo-replication, or Always On with correct readable secondary and failover policy settings. The most important thing: know which option gives automated failover with a readable, backup-capable secondary.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Plan and configure a high availability and disaster recovery environment questions in a focused session?
Yes — the session launcher on this page draws every question from the Plan and configure a high availability and disaster recovery environment domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other DP-300 topics?
Use the topic links above to move to related areas, or go back to the DP-300 question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the DP-300 exam covers. They are not copied from any real exam or dump site.