nerdexam
Microsoft

DP-300 · Question #313

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…

The correct answer is C. Connect each virtual machine to a single subnet on a single virtual network. To match the on-premises experience for connecting to your availability group listener, deploy your SQL Server VMs to multiple subnets within the same virtual network. Having multiple subnets negates the need for the extra dependency on an Azure Load Balancer, or a distributed…

Submitted by brentm· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment

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?

Options

  • AConnect each virtual machine to a different subnet on a virtual network. Deploy a basic Azure
  • BConnect each virtual machine to a different subnet on a single virtual network.
  • CConnect each virtual machine to a single subnet on a single virtual network.
  • DConnect each virtual machine to a single subnet on a virtual network. Deploy a standard Azure

How the community answered

(43 responses)
  • A
    14% (6)
  • B
    5% (2)
  • C
    60% (26)
  • D
    21% (9)

Explanation

To match the on-premises experience for connecting to your availability group listener, deploy your SQL Server VMs to multiple subnets within the same virtual network. Having multiple subnets negates the need for the extra dependency on an Azure Load Balancer, or a distributed network name (DNN) to route your traffic to your listener. ref: https://learn.microsoft.com/en- us/azure/azure-sql/virtual-machines/windows/availability-group-overview?view=azuresql-

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice