Plan and configure a high availability and disaster recovery environment →hardMultiple ChoiceObjective-mapped
DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment
You have a SQL Server on Azure VM that is part of a failover cluster instance (FCI). The cluster nodes are in an availability set. You need to ensure that the database can tolerate a complete Azure region failure. What should you add to the current architecture?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Deploy a second FCI in a different Azure region and configure SQL Server log shipping or availability group between the FCIs.
Deploying a second FCI in a different Azure region and configuring SQL Server log shipping or an availability group between the FCIs provides disaster recovery across regions. Option A is incorrect because adding a node in a different availability zone within the same region does not protect against a complete region failure. Option C is incorrect because geo-redundant backup storage only protects backups, not provide continuous replication for the database. Option D is incorrect because active geo-replication is a feature of Azure SQL Database, not SQL Server on Azure VM.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add another node to the existing FCI in a different availability zone.
Why it's wrong here
Availability zones are within the same region.
- ✓
Deploy a second FCI in a different Azure region and configure SQL Server log shipping or availability group between the FCIs.
Why this is correct
Cross-region replication provides DR.
- ✗
Configure geo-redundant backup storage for the SQL Server VMs.
Why it's wrong here
Backup does not provide continuous replication.
- ✗
Create an Azure SQL Database with active geo-replication and migrate the database.
Why it's wrong here
This would require a database migration, not an addition to the existing architecture.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
SQL Server on Azure VM
SQL Server on Azure VM is a cloud service that lets you run Microsoft SQL Server software inside a virtual machine in Microsoft Azure, giving you full control over the database environment just like you would have on your own physical server.
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
Courseiva writes every DP-300 question from scratch — 906 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 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 DP-300 exam.