ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam
Go to Exam

Exam 70-764 topic 1 question 162 discussion

Actual exam question from Microsoft's 70-764
Question #: 162
Topic #: 1
[All 70-764 Questions]

Your company has offices in Seattle and Montreal.
The network contains two servers named Server1 and Server2 that have SQL Server 2012 installed. Server1 is located in the Seattle office. Server2 is located in the Montreal office. The latency of the WAN link between the Montreal office and the Seattle office is more than 200 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?

  • A. Synchronous manual failover
  • B. Synchronous automatic failover
  • C. Asynchronous automatic failover
  • D. Asynchronous manual failover
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by a123c at Jan. 15, 2020, 3:26 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
mrn0107
Highly Voted 5 years, 5 months ago
Asynchronous failover is because of high latency, and asynchronous failover can only have manual failover, do not support automatic failover.
upvoted 6 times
...
TheSwedishGuy
Most Recent 5 years, 5 months ago
Asynchronous-commit replicas support only the manual failover mode. Moreover, because they are never synchronized, they support only forced failover. https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-and-failover-modes-always-on-availability-groups?view=sql-server-ver15
upvoted 2 times
...
TheSwedishGuy
5 years, 5 months ago
Even though the MS is 200, I'd like an async auto failover cluster. The reason they suggest there should be manual is because the latency is so high, that a few transactions might get lost before the hardening phase. The cost for auto failover as compared to manual is about 200ms worth of transactions lost for a much, much quicker failover.
upvoted 1 times
...
a123c
5 years, 6 months ago
ah, sorry, different latency
upvoted 2 times
247SQL
5 years, 6 months ago
what is the role of latency in this?
upvoted 1 times
...
...
a123c
5 years, 6 months ago
This question was before at 156 and the answer there was Synchronous automatic failover, which is correct?
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel