AZ-104 Certification Practice Question #28

Question

Note: The question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result. Establish if the solution satisfies the requirements.
Your company has a Microsoft SQL Server Always On availability group configured on their Azure virtual machines (VMs).
You need to configure an Azure internal load balancer as a listener for the availability group.
Solution: You set Session persistence to Client IP.
Does the solution meet the goal?

Accepted Answer

In an Azure Internal Load Balancer (ILB) configuration for a SQL Server Always On Availability Group listener, Session Persistence must be set to **None**. The Load Balancer relies on the health probe (which only the active primary replica responds to) to dynamically route traffic to the current primary replica. If Client IP persistence is enabled, clients would remain stickily routed to an offline replica during a failover, disrupting high-availability routing.

More AZ-104 practice questions