nerdexam
MicrosoftMicrosoft

70-465 · Question #89

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

Sign in or unlock 70-465 to reveal the answer and full explanation for question #89. The question stem and answer options stay visible for context.

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.

Unlock 70-465 to see the answer

You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#AlwaysOn Availability Groups#High Availability#Synchronous failover#WAN latency
Full 70-465 PracticeBrowse All 70-465 Questions