Always On Availability Groups Quiz

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

Quiz covering High Availability

What you'll be asked

  1. Which component is required to manage the cluster resources for SQL Server Always On Availability Groups on Windows Server?
  2. When configuring an Availability Group, what is the primary purpose of the Availability Group Listener?
  3. You have an Availability Group with two replicas set to 'Synchronous-commit' mode. What happens if the secondary replica becomes unresponsive?
  4. Which of the following is a requirement for a database to be added to an Always On Availability Group?
  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?

Answers and explanations come after you submit.