Auto-Failover Configuration Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering High Availability

What you'll be asked

  1. What is the primary purpose of configuring auto-failover in a high availability cluster?
  2. In a SQL Server Always On Availability Group, what does the 'FailureConditionLevel' property determine?
  3. When configuring a two-node cluster for high availability, why is a 'Witness' (or Quorum) component often required?
  4. Which configuration setting is critical to ensure that an auto-failover does not result in data loss in an asynchronous replication setup?
  5. You have a 3-node cluster. If the 'Quorum' model is set to 'Node Majority', how many nodes must be online for the cluster to remain functional?

Answers and explanations come after you submit.