Clustering for SQL Quiz

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

Quiz covering High Availability Solutions

What you'll be asked

  1. What is the primary purpose of a SQL Server Failover Cluster Instance (FCI)?
  2. In a Windows Server Failover Cluster (WSFC), what is the function of the 'Quorum'?
  3. Which component is required for a SQL Server Failover Cluster Instance (FCI) to store data that must be accessible by all nodes?
  4. When configuring a multi-subnet Failover Cluster Instance, what must be configured in the connection string to ensure the application can connect quickly after a failover?
  5. If you have a 4-node Windows Server Failover Cluster using a Node Majority quorum configuration, what is the minimum number of nodes that must be online for the cluster to remain functional?

Answers and explanations come after you submit.