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…
Question
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)- A14% (6)
- B5% (2)
- C60% (26)
- D21% (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.