Your Azure VMs host a SQL Server Always On availability group and you need an internal Azure load balancer to act as the AG listener. Solution: create an HTTP health probe that checks port 1433. Does this meet the requirement?
Choose an answer
Tap an option to check your answer.
Correct answer: No.
Why this is the answer
No, this solution does not meet the requirement. For a SQL Server Always On Availability Group (AG) listener with an internal Azure Load Balancer, the health probe must be configured to use the SQL Server IP address resource, not the SQL Server port directly. The probe should target the specific port configured for the AG listener's health probe (often 59999 or another high-numbered port), which is managed by the AG cluster resource. An HTTP probe on port 1433 would only check if SQL Server is listening, not whether the AG listener resource is active on the primary replica, which is crucial for failover.
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