What operation is available only with synchronous replication sessions?

Question

Options

• APlanned Failover
• BFailback
• CUnplanned Failover
• DResume

• A
  87% (34)
• B
  3% (1)
• C
  3% (1)
• D
  8% (3)

Explanation

Planned Failover (A) is exclusive to synchronous replication because it requires both the primary and secondary sites to be in a fully consistent, zero-lag state before switching roles. Synchronous replication guarantees this by confirming writes on the secondary before acknowledging them on the primary - making a clean, coordinated switchover possible with zero data loss.

Failback (B) is wrong because returning to the original primary after a failover is supported by both synchronous and asynchronous sessions. Unplanned Failover (C) is wrong because emergency failovers can be triggered on either replication type when the primary fails unexpectedly (asynchronous simply accepts potential data loss). Resume (D) is wrong because restarting a paused or broken replication session applies to both session types equally.

Memory tip: "Planned = Perfect." A planned failover demands perfection - zero data loss, fully synchronized state - which only synchronous replication can guarantee. If it's "planned," sync is required.

No community discussion yet for this question.