Question 290
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. Before changing the system, which evidence should the administrator examine FIRST?
Explanation
Correct Answer
Inspect cluster logs, Get-ClusterNode and Get-ClusterGroup results, heartbeat/network events, shared disk access, and role move history. This evidence tests the likely failure point before changing production configuration. 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. The corresponding 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.
Incorrect Answers
Inspect node patch baselines, CAU role/configuration, cluster health, available workload capacity, live migration settings, and update failure events. This examines Cluster-Aware Updating and maintenance orchestration, a different fault or management boundary. For this case the decisive evidence is: 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.
Review cluster validation tests, IP resource dependencies, DNS registration, preferred owner settings, network adapter roles, and application client reconnect logs. This examines Failover cluster roles, client access and network configuration, a different fault or management boundary. For this case the decisive evidence is: 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.
Review number of nodes, storage resiliency setting, mirror/parity layout, storage fault domains, capacity forecast and rebalance status. This examines S2D resilient volume layout and safe node expansion, a different fault or management boundary. For this case the decisive evidence is: 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.


