Administering a SQL Database Infrastructure — Question 146

Your company has offices in Seattle and Montreal.
The network contains two servers named Server1 and Server2 that have SQL Server 2012 installed. The servers are located in separate building within your campus.
The latency of the WAN link between the buildings is less than 10 ms.
You plan to implement an AlwaysOn availability group on both servers.
You need to recommend a failover type for the availability group.
What should you recommend?

Answer options

Correct answer: D

Explanation

The correct answer is D, Synchronous automatic failover, because with a low latency of less than 10 ms, synchronous replication is feasible and provides automatic failover capabilities, ensuring high availability. The other options either do not utilize the low latency effectively (A and C) or do not provide automatic failover (B), which is essential for maintaining uptime in case of a failure.