Plan and configure a high availability and disaster recovery environment →mediumMultiple ChoiceObjective-mapped
DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment
You have an Azure SQL Database that uses active geo-replication with a readable secondary in another region. You need to ensure that if a failover occurs, the application can automatically reconnect to the new primary with minimal code changes. What should you configure?
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
✓
Implement retry logic in the application to reconnect to the secondary server after failover.
With active geo-replication, there is no automatic listener endpoint. To achieve automatic reconnection with minimal code changes, the application should implement retry logic in the connection string that includes the failover partner (secondary) and set ApplicationIntent=ReadWrite. When the primary is unavailable, the driver will automatically attempt to connect to the secondary. Option A is incorrect because manually updating DNS is not automatic and requires manual intervention, which violates the 'minimal code changes' requirement. Option B is incorrect because a failover group listener endpoint is specific to failover groups, not active geo-replication; configuring a failover group would be a different setup. Option C is incorrect because using Azure Traffic Manager introduces additional complexity and is not considered minimal code change; it requires managing a separate DNS service.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Manually update the DNS record to point to the new primary after failover.
Why it's wrong here
This is incorrect because manually updating the DNS record after failover is not automatic and requires changes to the application or operations, which defeats the goal of minimal code changes.
- ✗
Configure a failover group listener endpoint and use that in the connection string.
Why it's wrong here
This is incorrect because a failover group listener endpoint is not available with active geo-replication; it is a feature of failover groups. Active geo-replication requires the application to handle failover detection and reconnection.
- ✗
Use Azure Traffic Manager with priority routing to the secondary server.
Why it's wrong here
This is incorrect because while Azure Traffic Manager can redirect traffic, it adds unnecessary complexity and still requires the application to reconnect to the new primary; it does not provide a single endpoint for the database itself.
- ✓
Implement retry logic in the application to reconnect to the secondary server after failover.
Why this is correct
This is correct because implementing retry logic in the application allows it to automatically detect the failover and reconnect to the new primary with minimal code changes, typically by using a connection string with 'ApplicationIntent=ReadWrite' and retry policies.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
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
This DP-300 question is part of Courseiva's 906-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-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.