DP-300 Certification Practice Question #247

Question

You have an Azure subscription.

You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:

•	Minimize how long it takes to fail over.
•	Maintain existing connections to the primary replica during a failover.

What should you do?

Accepted Answer

When configuring an Always On availability group in Azure VMs using a single subnet (Option C), you can configure a Distributed Network Name (DNN) listener instead of a traditional load balancer (VNN). The DNN listener provides two major advantages that map directly to the requirements: it minimizes failover time because it bypasses the load balancer probe delay, and it allows other connections to the primary replica (e.g., to databases not participating in the failing-over availability group) to remain open because the DNN endpoint itself stays online during failover. Therefore, deploying SQL Server VMs to a single subnet without a load balancer (via DNN) is the correct answer.

More DP-300 practice questions