nerdexam
CompTIA

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.

Security and disaster recovery

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)
  • A
    30% (6)
  • B
    15% (3)
  • C
    5% (1)
  • D
    50% (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.

AFailover back to the original active node once the patching is complete

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.

BKeep services failed over to passive node once patching is complete

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.

CMove services to the active node and repeat for the passive node

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.

DPatch the passive node, failover, and patch the other nodeCorrect

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

#active-passive failover#patch management#SQL cluster#high availability maintenance

Community Discussion

No community discussion yet for this question.

Full SK0-004 Practice