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.
Explanation:
http://msdn.microsoft.com/en-gb/library/ff929171.aspx
0
0
So the leve of data loss is not a requirement?
0
0
The questions requires a solution for high-availability, and the latency is high, so asynchronous commit would be the best option, now since will be use asynchronous commit it does not allow automatic failover, so the best answer is A.
0
0