Clustering for SQL Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering High Availability Solutions

Clustering for SQL 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 a SQL Server Failover Cluster Instance (FCI)?

  2. 2

    In a Windows Server Failover Cluster (WSFC), what is the function of the 'Quorum'?

  3. 3

    Which component is required for a SQL Server Failover Cluster Instance (FCI) to store data that must be accessible by all nodes?

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