SK0-004 · Question #433
A server technician is applying a security patch to an active-passive failover SQL cluster. However, the cluster must continue to service clients during the process with limited outages. Given this…
The correct answer is D. Patch the passive node, failover, and patch the other node. Rolling patch methodology on an active-passive cluster - patch passive first, failover, then patch the other node - keeps clients serviced with only a brief, planned outage.
Question
A server technician is applying a security patch to an active-passive failover SQL cluster. However, the cluster must continue to service clients during the process with limited outages. Given this scenario, which of the following should the technician do to adhere to these maintenance requirements?
Options
- AFailover back to the original active node once the patching is complete
- BKeep services failed over to passive node once patching is complete
- CMove services to the active node and repeat for the passive node
- DPatch the passive node, failover, and patch the other node
How the community answered
(20 responses)- A30% (6)
- B15% (3)
- C5% (1)
- D50% (10)
Why each option
Rolling patch methodology on an active-passive cluster - patch passive first, failover, then patch the other node - keeps clients serviced with only a brief, planned outage.
Failing back to the original active node is an optional post-maintenance step that does not describe how to patch both nodes while keeping service available throughout.
Keeping services on the passive node after patching only addresses where services end up, not the procedure for patching both cluster nodes with minimal disruption.
Moving services to the active node and then patching it means patching the node that is actively serving clients, which would cause unplanned service disruption.
Patching the passive node first causes zero service impact because it is not servicing clients. After patching, a controlled failover transfers client connections to the newly patched node, resulting in only a brief, planned interruption. The original active node - now passive - can then be patched safely, completing the update of both nodes while meeting the limited-outage requirement.
Concept tested: Rolling patch procedure on active-passive SQL cluster
Source: https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server
Topics
Community Discussion
No community discussion yet for this question.