Which of the following failover types should you configure for the availability group?

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 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.

View Answer

Answer: A