SQL Server 2012 infrastructure. You are configuring a highly-available database solution using an AlwaysOn
availability group on two servers running SQL Server 2012. The two servers are in separate datacenters. The
two datacenters are connected by a WAN link with a network latency of more than 200ms. Which of the
following failover types should you configure for the availability group?
A.
You should configure the asynchronous manual failover failover type.
B.
You should configure the synchronous manual failover failover type.
C.
You should configure the synchronous automatic failover failover type.
D.
You should configure the Asynchronous automatic failover failover type.
Why not D?
Correct answer = A.
D cannot be implemented because “Automatic failover” exists ONLY in “Synchronous” mode. In asynchronous mode (recommended when latency is high as in our case), only “manual failover” is available
makes sense, thanks