nerdexam
Microsoft

70-465 · Question #90

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…

The correct answer is A. You should configure the asynchronous manual failover failover type. Due to the high network latency exceeding 200ms between datacenters, an asynchronous commit mode is necessary to prevent severe performance degradation, which mandates manual failover.

Submitted by daniela_cl· Mar 5, 2026Design and implement database solutions for SQL Server

Question

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?

Options

  • AYou should configure the asynchronous manual failover failover type.
  • BYou should configure the synchronous manual failover failover type.
  • CYou should configure the synchronous automatic failover failover type.
  • DYou should configure the Asynchronous automatic failover failover type.

How the community answered

(54 responses)
  • A
    63% (34)
  • B
    9% (5)
  • C
    22% (12)
  • D
    6% (3)

Why each option

Due to the high network latency exceeding 200ms between datacenters, an asynchronous commit mode is necessary to prevent severe performance degradation, which mandates manual failover.

AYou should configure the asynchronous manual failover failover type.Correct

Asynchronous commit mode tolerates high network latency by allowing transactions to commit on the primary replica without waiting for acknowledgement from the secondary replica, making it suitable for geographically dispersed datacenters with WAN links; automatic failover is not supported with asynchronous commit, requiring manual failover.

BYou should configure the synchronous manual failover failover type.

Synchronous commit mode would severely impact application performance over a WAN link with more than 200ms latency, as each transaction must wait for confirmation from the secondary replica before committing on the primary.

CYou should configure the synchronous automatic failover failover type.

Synchronous commit mode is unsuitable for high-latency WAN links due to performance impact, and while automatic failover requires synchronous commit, the high latency makes the commit mode impractical.

DYou should configure the Asynchronous automatic failover failover type.

Automatic failover functionality in SQL Server AlwaysOn Availability Groups explicitly requires synchronous commit mode, making 'Asynchronous automatic failover' an invalid configuration choice.

Concept tested: SQL Server AlwaysOn Availability Groups commit modes and failover types with latency

Source: https://learn.microsoft.com/en-us/sql/database/availability-group-modes-always-on-availability-groups

Topics

#AlwaysOn Availability Groups#Disaster Recovery#Asynchronous failover#WAN latency

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice