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 fast WAN link with a network latency
of less than 10ms.
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 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.

Explanation:

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

Max (BR)

Max (BR)

The questions requires a solution for high-availability, and the latency is low, so synchronous commit would be the best option, now since will be use synchronous commit it allows automatic failover, which is the best than a manual failover, so the best answer is C.

Reply