Always On Availability Groups Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering High Availability

Always On Availability Groups 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

    Which component is required to manage the cluster resources for SQL Server Always On Availability Groups on Windows Server?

  2. 2

    When configuring an Availability Group, what is the primary purpose of the Availability Group Listener?

  3. 3

    You have an Availability Group with two replicas set to 'Synchronous-commit' mode. What happens if the secondary replica becomes unresponsive?

  4. 4

    Which of the following is a requirement for a database to be added to an Always On Availability Group?

  5. 5

    You are troubleshooting a scenario where a manual failover to a secondary replica is failing. The secondary replica is in 'Synchronous-commit' mode, but the 'Synchronization State' shows 'NOT SYNCHRONIZING'. What is the most likely cause?