Home > Sample chapters

Manage high availability and disaster recovery

Thought experiment answers

This section contains the solution to the thought experiment. Each answer explains why the answer choice is correct.

Question 1

1. Correct answer: D

  1. Incorrect: You can’t meet your snapshot reporting with a replica in Wagga Wagga.

  2. 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.

  3. Incorrect: You cannot scale out or offload reporting using failover clustering.

  4. Correct: Availability Group in Sydney provides high availability and offloads reporting. Log shipping provides the snapshot reporting.

Question 2

2. Correct answer: C

  1. 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.

  2. Incorrect: A fileshare witness in either data center might prevent quorum if the WAN link has problems.

  3. Correct: A cloud witness is designed for such scenarios where you do not have a third data center.

  4. Incorrect: A disk witness in either data center might prevent quorum if the WAN link has problems

Question 3

3. Correct answer: D

  1. Incorrect: You cannot take a database offline when it is part of an Availability Group.

  2. Correct: You cannot drop a database when it is part of an Availability Group.

  3. Incorrect: This will not meet your high availability and time constraint requirements.

  4. Correct: This will allow the database to use the new space while maintaining high availability and incur no downtime.