SK0-004 · Question #70
A system administrator is tasked to setup a database server with failover clustering feature enabled. One of the requirements is to have one database running at all times with data being…
The correct answer is B. Active/Passive. Active/Passive clustering keeps one node running while a standby node replicates data and takes over only on failure, matching the described requirements.
Question
A system administrator is tasked to setup a database server with failover clustering feature enabled. One of the requirements is to have one database running at all times with data being synchronized and replicated to the idle database in case the primary database server fails. Both servers will be monitored by a witness on a LUN. Which of the following cluster techniques should be implemented to meet these requirements?
Options
- AActive/Active
- BActive/Passive
- CSingle Local Quorum
- DPassive/Passive
- EShared Multiple Quorum
How the community answered
(18 responses)- A11% (2)
- B78% (14)
- C6% (1)
- E6% (1)
Why each option
Active/Passive clustering keeps one node running while a standby node replicates data and takes over only on failure, matching the described requirements.
Active/Active clustering has both nodes serving workloads simultaneously, which does not match the requirement of one idle/passive database.
In an Active/Passive cluster, the primary node handles all workloads while the passive node stays idle and continuously synchronizes data. A witness (quorum disk on a LUN) monitors both nodes and determines which should become active if the primary fails, satisfying the requirement of one database always running with replication to the idle node.
Single Local Quorum is a quorum disk configuration type, not a cluster role technique describing how nodes share workload.
Passive/Passive is not a valid cluster configuration because no node would be actively serving the database at any time.
Shared Multiple Quorum is a quorum model for multi-site clusters and does not describe the active-versus-standby node role requirement.
Concept tested: Active/Passive failover clustering with quorum witness
Source: https://learn.microsoft.com/en-us/windows-server/failover-clustering/failover-clustering-overview
Topics
Community Discussion
No community discussion yet for this question.