Administering a SQL Database Infrastructure — Question 26

You are implementing a SQL Server 2016 five-node failover cluster.
You need to choose a quorum configuration.
Which configuration should you use?

Answer options

• A. Distributed File System (DFS)
• B. Node Majority
• C. Cluster Shared Volume (CSV)
• D. Node and Disk Majority

Correct answer: D

Explanation

The correct answer is D, Node and Disk Majority, as it provides a reliable quorum configuration for a multi-node setup, ensuring that the cluster can maintain operation even if some nodes fail. Options A, B, and C do not offer the same level of fault tolerance or are not suitable for a five-node cluster environment.