Question 380
A two-node SQL cluster reports a stopped cluster service on one member and the other can see storage but has lost its witness vote. Which administrative configuration or response BEST addresses the primary requirement?
Explanation
Correct Answer
Recover a failed node by identifying its hardware, cluster service, network and storage state, then move or drain roles safely and validate ownership on surviving nodes. This response targets the system boundary described in the case. A clustered role can fail over only when a remaining node has quorum, storage/network access and application dependencies; forced starts are not always safe. Before applying it, verify: Inspect cluster logs, Get-ClusterNode and Get-ClusterGroup results, heartbeat/network events, shared disk access, and role move history. Situation: A two-node SQL cluster reports a stopped cluster service on one member and the other can see storage but has lost its witness vote.
Incorrect Answers
Configure validated high-bandwidth cluster networking with Network ATC intents on supported Windows Server platforms and check SMB Direct/RDMA settings, VLANs and adapter symmetry. This would address Network ATC intent and SMB Direct/RDMA for S2D, not the controlling issue in this situation. Network ATC automates consistent host network intent where supported but cannot compensate for mismatched NIC hardware, unsuitable switch configuration, or unavailable RDMA support. The targeted response is: Recover a failed node by identifying its hardware, cluster service, network and storage state, then move or drain roles safely and validate ownership on surviving nodes. Situation: A two-node SQL cluster reports a stopped cluster service on one member and the other can see storage but has lost its witness vote.
Set a Windows Server failover cluster quorum model appropriate to node count and site layout, and configure an Azure Cloud Witness or supported file share witness to maintain correct voting. This would address Cluster quorum and Azure Cloud Witness selection, not the controlling issue in this situation. A witness contributes to quorum voting and split-brain prevention, not an application data replica; witness placement should avoid sharing the same failure domain. The targeted response is: Recover a failed node by identifying its hardware, cluster service, network and storage state, then move or drain roles safely and validate ownership on surviving nodes. Situation: A two-node SQL cluster reports a stopped cluster service on one member and the other can see storage but has lost its witness vote.
Perform supported rolling upgrades of Windows Server failover cluster nodes, preserving workload compatibility and deferring cluster functional-level upgrade until rollback requirements are resolved. This would address Rolling OS upgrade and cluster functional level, not the controlling issue in this situation. A cluster functional-level upgrade changes interoperability and rollback conditions; upgrading one member is not identical to committing the entire cluster to new behavior. The targeted response is: Recover a failed node by identifying its hardware, cluster service, network and storage state, then move or drain roles safely and validate ownership on surviving nodes. Situation: A two-node SQL cluster reports a stopped cluster service on one member and the other can see storage but has lost its witness vote.


