DP-300 · Question #366
You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2019 CU8. You need to deploy a failover…
The correct answer is D. Connect VM1 and VM2 to different subnets 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
- ADeploy VM1 and VM2 to a single proximity placement group.
- BDeploy VM1 and VM2 to different proximity placement groups in the same Azure region.
- CConnect VM1 and VM2 to a single subnet.
- DConnect VM1 and VM2 to different subnets on a single virtual network.
How the community answered
(34 responses)- A24% (8)
- B6% (2)
- C12% (4)
- D59% (20)
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. 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.