As part of an integrity check, a database administrator is creating both the primary and secondary snapshots. The database administrator notices the primary replica is failing over to the secondary…

Question

Options

• AAll the data will have to be copied to a new primary snapshot.
• BThe database will not be impacted.
• CThe database will shut down unexpectedly.
• DAll the information in the database will be lost.

• A
  18% (10)
• B
  71% (40)
• C
  4% (2)
• D
  7% (4)

Explanation

Option B is correct because database replication with primary and secondary replicas is specifically designed for high availability - when a failover occurs, the secondary replica seamlessly assumes the primary role, keeping the database operational without interruption or data loss. This is the entire purpose of maintaining synchronized replicas.

Why the distractors are wrong:

• A is wrong because the secondary replica already holds a synchronized copy of the data; no bulk data copy is needed during failover.
• C is wrong because failover is an automated, graceful transition - the opposite of an unexpected shutdown.
• D is wrong because replication continuously mirrors data to the secondary; failover preserves all data, it does not destroy it.

Memory tip: Think of primary/secondary replicas like a relay race - when the lead runner (primary) stumbles, the backup runner (secondary) immediately takes the baton without dropping it or stopping the race. The goal of failover is continuity, not disruption.

No community discussion yet for this question.