Administering a SQL Database Infrastructure — Question 57

Your company has offices in Seattle and Montreal.
The network contains two servers named Server1 and Server2 that have SQL Server 2012 installed. Server1 is located in the Seattle office. Server2 is located in the Montreal office. The latency of the WAN link between the Montreal office and the Seattle office is more than 200 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, Asynchronous manual failover, because with high latency (over 200 ms), synchronous options would not be feasible due to the risk of performance degradation. Asynchronous manual failover allows for data to be sent without the need for immediate acknowledgment, making it suitable for geographically dispersed locations.