You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
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 fast WAN link with a network latency of less than 10ms. 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.
Correct. C is the option – network latency is lower, so synchronous mode could be used. In that case, automatic failover is the best choice.