Same SQL Always On scenario. Solution: set the load balancer's Session persistence to Client IP. Does this satisfy the requirement for the AG listener?
Choose an answer
Tap an option to check your answer.
Correct answer: No.
Why this is the answer
Setting the load balancer's session persistence to Client IP does not satisfy the requirement for an Always On Availability Group (AG) listener. An AG listener requires direct communication with the primary replica, and client IP affinity can interfere with failover. If a failover occurs, the client's connection might still be directed to the old primary replica (which is now a secondary) due to the sticky session, preventing the connection from reaching the new primary. For AG listeners, the load balancer should typically use Direct Server Return (DSR) or a similar method that allows the listener IP to float between replicas without session persistence issues.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed