70-465 Question #24: Real Exam Question with Answer & Explanation

Question

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?

Options

• AAsynchronous automatic failover
• BSynchronous manual failover
• CAsynchronous manual failover
• DSynchronous automatic failover

Explanation

Given the less than 10 ms latency between servers, synchronous commit mode is feasible, enabling automatic failover for zero data loss and high availability in the AlwaysOn availability group.

Common mistakes.

• A. Asynchronous automatic failover is incorrect because automatic failover requires replicas to be in synchronous-commit mode, and asynchronous commit allows for potential data loss, which is undesirable if network conditions support synchronous commit.
• B. Synchronous manual failover is not optimal because, while synchronous commit is appropriate, manual failover introduces unnecessary downtime and administrative overhead when automatic failover is achievable and provides higher availability.
• C. Asynchronous manual failover is the least desirable option as asynchronous commit allows for data loss, and manual failover further increases downtime, neither of which is necessary given the low network latency.

Concept tested. SQL Server AlwaysOn Availability Group failover types

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

No community discussion yet for this question.