DP-300 Practice Question: Plan and configure high availability and disaster recovery
You manage an Azure SQL Database named OrdersDB in the East US region. The business requires that OrdersDB be readable from a secondary region during a planned regional failover, and that the failover be initiated manually by a database administrator. You create a failover group and add OrdersDB as a member. Which read-write listener endpoint should applications use to connect to OrdersDB after a manual failover to the secondary region?
⚠ Common exam trap
The trap here is assuming that the original server name or a private endpoint IP will continue to work after a regional failover, when only the failover group listener is designed to redirect clients.
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
✓
The read-write listener endpoint of the failover group.
A failover group provides a read-write listener endpoint that automatically redirects connections to the current primary database after a failover. Applications use this listener rather than server-specific names or region-specific endpoints, so connectivity is maintained without connection string changes. The read-only listener is only for read-only workloads, and private endpoint IPs are region-bound and unsuitable for cross-region failover.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The original server name of OrdersDB in the East US region.
Why it's wrong here
The original server name resolves to the primary server in East US and does not redirect clients to the secondary region. After failover, the read-write listener endpoint is the supported connection point; using the original server name would either fail or continue to target the wrong region, so it does not satisfy the requirement for connectivity during a regional failover.
- ✗
The read-only listener endpoint of the failover group.
Why it's wrong here
The read-only listener endpoint is intended for read-only workloads and routes connections to the secondary replica. It cannot be used for read-write operations, and after a failover it may not point to the new primary. Because the scenario requires read-write access to OrdersDB after failover, the read-only listener is not appropriate.
- ✓
The read-write listener endpoint of the failover group.
Why this is correct
The failover group exposes a read-write listener endpoint that always points to the current primary database. After a manual failover, the listener is updated to route connections to the secondary region, allowing applications to reconnect without changing connection strings. This endpoint is the correct choice for read-write access that must survive a regional failover.
- ✗
The private endpoint IP address of OrdersDB in the East US region.
Why it's wrong here
A private endpoint IP address is tied to a specific virtual network and region. During a regional failover, the private endpoint in East US would no longer serve the primary database, and clients in the secondary region would not be able to use it. This does not provide the required automatic redirection to the new primary.
Go deeper
Related to this question
Learn chapter
Deploying and Configuring SQL Server on Azure Virtual Machines
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 — 574 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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
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.