Your company

has offices in Seattle and Montreal.

The network contains two servers named Server1 and Server2 that have SQL Server 2012 installed. The servers are located in separate building within your campus.

The latency of the WAN link between the buildings is

less than 10 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?

A. Asynchronous automatic failover

B. Synchronous manual failover

C. Asy

nchronous manual failover

D. Synchronous automatic failover

Your company has offices in Seattle and Montreal.

The networ

k 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 mo

re 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?

A. Synchronous manual failover

B. Synchronous automatic failover

C.

Asynchronous automatic failover

D. Asynchronous manual failover