Same SQL Always On scenario. Solution: enable Floating IP (direct server return) on the internal load balancer. Does this meet the requirement?
Choose an answer
Tap an option to check your answer.
Correct answer: Yes.
Why this is the answer
Yes, enabling Floating IP (Direct Server Return) on the internal load balancer is the correct solution for an Azure SQL Always On Availability Group listener. This setting allows the secondary replicas to respond directly to client requests without the traffic having to pass back through the load balancer. This is crucial for SQL Always On listeners because it ensures that all nodes in the availability group can participate in the listener's IP address, even when they are not the primary replica. Without Floating IP, only the primary replica could respond, breaking the listener's functionality during failovers or when secondary replicas are accessed for read-only workloads.
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