Microsoft Azure Architect Technologies (legacy) — Question 69

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?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D, as enabling Floating IP allows the load balancer to direct traffic to the appropriate SQL Server instances in the availability group. Options A, B, and C are related to session management and health checks but do not address the requirement to properly configure the load balancer as a listener.