Auto-Failover Configuration Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering High Availability

Auto-Failover Configuration Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    What is the primary purpose of configuring auto-failover in a high availability cluster?

  2. 2

    In a SQL Server Always On Availability Group, what does the 'FailureConditionLevel' property determine?

  3. 3

    When configuring a two-node cluster for high availability, why is a 'Witness' (or Quorum) component often required?

  4. 4

    Which configuration setting is critical to ensure that an auto-failover does not result in data loss in an asynchronous replication setup?

  5. 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?