nerdexam
Microsoft

70-465 · Question #89

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 C. You should configure the synchronous automatic failover failover type. For AlwaysOn Availability Groups spanning two datacenters with low network latency (under 10ms), synchronous automatic failover provides both data protection and automatic recovery without manual intervention.

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

(33 responses)
  • A
    18% (6)
  • B
    15% (5)
  • C
    61% (20)
  • D
    6% (2)

Why each option

For AlwaysOn Availability Groups spanning two datacenters with low network latency (under 10ms), synchronous automatic failover provides both data protection and automatic recovery without manual intervention.

AYou should configure the asynchronous manual failover failover type.

Asynchronous manual failover uses asynchronous-commit mode, which does not guarantee zero data loss and requires manual intervention, making it inappropriate when the low-latency WAN link supports synchronous replication.

BYou should configure the synchronous manual failover failover type.

Synchronous manual failover provides zero data loss but still requires a DBA to manually initiate failover, reducing availability compared to automatic failover when the environment supports it.

CYou should configure the synchronous automatic failover failover type.Correct

Synchronous-commit mode ensures zero data loss by requiring the secondary replica to harden log records before the primary acknowledges a transaction commit, making it suitable for low-latency WAN links under 10ms. Automatic failover allows SQL Server to automatically transition the secondary to the primary role without DBA intervention when a failure is detected, maximizing availability. This combination is the recommended configuration when latency is low enough to avoid significant performance impact from the synchronous commit overhead.

DYou should configure the Asynchronous automatic failover failover type.

Asynchronous automatic failover is not a supported combination in SQL Server AlwaysOn Availability Groups; automatic failover is only available with synchronous-commit mode replicas.

Concept tested: AlwaysOn AG failover modes and commit synchronization

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

Topics

#AlwaysOn Availability Groups#High Availability#Synchronous failover#WAN latency

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice