exam questions

Exam AZ-303 All Questions

View all questions & answers for the AZ-303 exam

Exam AZ-303 topic 6 question 21 discussion

Actual exam question from Microsoft's AZ-303
Question #: 21
Topic #: 6
[All AZ-303 Questions]

You have a Microsoft SQL Server Always On availability group on Azure virtual machines.
You need to configure an Azure internal load balancer as a listener for the availability group.
What should you do?

  • A. Create an HTTP health probe on port 1433.
  • B. Set Session persistence to Client IP.
  • C. Set Session persistence to Client IP and protocol.
  • D. Enable Floating IP.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-alwayson-int-listener

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Tripp_F
Highly Voted 3 years, 11 months ago
Floating IP is correct, used for SQL always on availability. The probe uses TCP, not HTTP. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-load-balancer-portal-configure
upvoted 13 times
rdemontis
3 years, 10 months ago
thanks for explanation
upvoted 2 times
...
...
syu31svc
Most Recent 3 years, 9 months ago
Create an HTTP health probe on port 1433 - Health probe must be configured on TCP. Set Session persistence to Client IP - Specifies that successive requests from the same client IP address will be handled by the same virtual machine. This setting is not required to configure for MS SQL always on. Set Session persistence to Client IP and protocol - Specifies that successive requests from the same client IP address and protocol combination will be handled by the same virtual machine. This setting is not required to configure for MS SQL always on. Answer is D
upvoted 2 times
...
Yiannisthe7th
3 years, 11 months ago
D. Enable Floating IP.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...