- By Victor Isakov
Thought experiment answers
This section contains the solution to the thought experiment. Each answer explains why the answer choice is correct.
1. Correct answer: D
Incorrect: You can’t meet your snapshot reporting with a replica in Wagga Wagga.
Incorrect: You can’t meet your snapshot reporting with a replica in Wagga Wagga. A DAG with only one replica in Wagga Wagga is effectively the same as option A.
Incorrect: You cannot scale out or offload reporting using failover clustering.
Correct: Availability Group in Sydney provides high availability and offloads reporting. Log shipping provides the snapshot reporting.
2. Correct answer: C
Incorrect: With only 2 nodes at each site the cluster might shut down if the WAN link goes down and a node in Sydney fails.
Incorrect: A fileshare witness in either data center might prevent quorum if the WAN link has problems.
Correct: A cloud witness is designed for such scenarios where you do not have a third data center.
Incorrect: A disk witness in either data center might prevent quorum if the WAN link has problems
3. Correct answer: D
Incorrect: You cannot take a database offline when it is part of an Availability Group.
Correct: You cannot drop a database when it is part of an Availability Group.
Incorrect: This will not meet your high availability and time constraint requirements.
Correct: This will allow the database to use the new space while maintaining high availability and incur no downtime.