DP-900 Practice Question: Identify considerations for relational data on Azure
A company runs an e-commerce application backed by an on-premises SQL Server database. They plan to migrate to Azure SQL Database and require automatic failover across two Azure regions for disaster recovery. The application must continue to connect using the same connection string after a failover, with no code changes. Which feature should they implement?
⚠ Common exam trap
A common mix-up: candidates confuse Active Geo-Replication with Failover groups, not realizing that only Failover groups provide a single, unchanged connection string endpoint for automatic failover, while Active Geo-Replication requires manual connection string updates.
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
✓
Failover groups
Failover groups (Option C) enable automatic, geo-redundant failover across two Azure regions while providing a single read-write listener endpoint that remains unchanged after failover. This ensures the application can continue using the same connection string without any code modifications, meeting the stated requirement for disaster recovery with zero application changes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Active Geo-Replication
Why it's wrong here
Active Geo-Replication is a per-database feature that maintains readable secondary replicas in another region, but failover is strictly manual or must be driven by custom automation. There is no built-in listener; each database has its own connection string, so after a manual failover the application would need to update its connection details unless you build a custom routing layer. Because the requirement is automatic failover with no code changes, this option does not satisfy the stated need.
When this WOULD be correct
Active Geo-Replication would be correct if the question required read-scale workloads or allowed manual failover with connection string updates, such as: 'You need to replicate a database to a secondary region for read-only queries and are willing to update the connection string after a manual failover.'
- ✗
Elastic pools
Why it's wrong here
Elastic pools are a resource-management tool that allocates shared vCores, memory, and IO among multiple databases on a single logical server. They are designed for cost and performance isolation, not for replication or disaster recovery, and they have no cross-region or automatic failover concept. Placing databases in an elastic pool does nothing to protect against an entire region outage, so it cannot meet the failover requirement.
When this WOULD be correct
A company has multiple Azure SQL databases with unpredictable usage patterns and wants to optimize cost by sharing resources across databases while ensuring performance isolation.
- ✓
Failover groups
Why this is correct
Failover groups are the correct choice because they automatically replicate databases or elastic pools to a secondary region and provide an automatic failover mechanism that requires no application code changes. The group exposes a single readable/writable listener endpoint that remains identical after failover, so clients keep connecting to the same fully qualified domain name. You can also set a graceful data-loss boundary (RPO) and configure a read-only listener for offloading reporting traffic, making it a fully managed, PaaS-native DR solution.
- ✗
SQL Server on Azure Virtual Machine with Always On Availability Groups
Why it's wrong here
SQL Server on Azure Virtual Machines with Always On Availability Groups can deliver cross-region high availability, but it is an IaaS solution that requires you to manage Windows Server, SQL Server installations, patching, and the availability group configuration. You would have to manually set up an internal load balancer and listener, and you still need custom health probes to make failover truly automatic. The scenario explicitly calls for Azure SQL Database, so moving to IaaS adds significant administrative overhead and does not provide the managed failover group simplicity or the same 'no code change' guarantee.
When this WOULD be correct
This option would be correct if the question specified that the company needs full control over the SQL Server instance, requires compatibility with on-premises features like SQL Server Agent or CLR, or needs to lift-and-shift existing Always On configurations without redesigning the application.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.
✓Failover groupsCorrect answer▾
Why this is correct
Failover groups are the correct choice because they automatically replicate databases or elastic pools to a secondary region and provide an automatic failover mechanism that requires no application code changes. The group exposes a single readable/writable listener endpoint that remains identical after failover, so clients keep connecting to the same fully qualified domain name. You can also set a graceful data-loss boundary (RPO) and configure a read-only listener for offloading reporting traffic, making it a fully managed, PaaS-native DR solution.
✗Active Geo-ReplicationWrong answer — click to see why▾
Why this is wrong here
Active Geo-Replication does not support automatic failover with the same connection string; it requires manual failover and connection string changes, whereas the question demands automatic failover with no code changes.
★ When this WOULD be the correct answer
Active Geo-Replication would be correct if the question required read-scale workloads or allowed manual failover with connection string updates, such as: 'You need to replicate a database to a secondary region for read-only queries and are willing to update the connection string after a manual failover.'
Why candidates choose this
Candidates may confuse Active Geo-Replication with Failover Groups because both involve geo-replication, but they overlook that Failover Groups provide the automatic failover and listener endpoint needed for transparent connection string continuity.
✗Elastic poolsWrong answer — click to see why▾
Why this is wrong here
Elastic pools are used to manage and scale multiple databases with varying resource demands, not for disaster recovery or automatic failover with a single connection string.
★ When this WOULD be the correct answer
A company has multiple Azure SQL databases with unpredictable usage patterns and wants to optimize cost by sharing resources across databases while ensuring performance isolation.
Why candidates choose this
Candidates may confuse elastic pools with high-availability features because both involve multiple databases, but elastic pools address resource management, not failover.
✗SQL Server on Azure Virtual Machine with Always On Availability GroupsWrong answer — click to see why▾
Why this is wrong here
SQL Server on Azure VM with Always On Availability Groups requires managing VMs and does not provide a single connection string that remains unchanged after failover without additional configuration like a listener, which is not the simple, managed solution the question requires.
★ When this WOULD be the correct answer
This option would be correct if the question specified that the company needs full control over the SQL Server instance, requires compatibility with on-premises features like SQL Server Agent or CLR, or needs to lift-and-shift existing Always On configurations without redesigning the application.
Why candidates choose this
Candidates may confuse the high-availability capabilities of Always On Availability Groups with the managed failover groups feature, assuming that the VM-based solution can also provide automatic failover with a constant connection string, overlooking the additional complexity and management overhead.
Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Go deeper
Related to this question
About these practice questions
This DP-900 question is part of Courseiva's 820-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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-900 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-900 exam.