Exam AZ-120 topic 2 question 39 discussion

Actual exam question from Microsoft's AZ-120

Question #: 39
Topic #: 2

HOTSPOT
-

You have an Azure subscription. The subscription contains two virtual machines named SQL1 and SQL2 that host a Microsoft SQL Server 2019 Always On availability group named AOG1.

You plan to deploy an SAP NetWeaver system that will have a database tier hosted on AOG1.

You need to configure networking for SQL1 and SQL2. The solution must meet the following requirements:

• Eliminate the need to create a distributed network name (DNN).
• Minimize costs.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by smudo1965 at Feb. 12, 2024, 12:16 p.m.

Comments

Submit Cancel

25max

2 days, 10 hours ago

First is correct: Network configuration Deploy your SQL Server VMs to multiple subnets whenever possible to avoid the dependency on an Azure Load Balancer or a distributed network name (DNN) to route traffic to your availability group listener. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-overview?view=azuresql#network-configuration

upvoted 1 times

...

smudo1965

6 months ago

Following this https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/hadr-cluster-best-practices?view=azuresql&tabs=windows2012#connectivity and this https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-ver16 First answer is correct second answer should the first

upvoted 3 times

...

Exam AZ-120 All Questions

View all questions & answers for the AZ-120 exam

Exam AZ-120 topic 2 question 39 discussion

Comments

25max

smudo1965

SY0-701