An SQL regional failover can be planned while both primary and secondary are healthy, or forced after the primary is unreachable. Which statement should the runbook reflect?

Choose the single best answer.

A.A supported planned failover can synchronize before switching; forced asynchronous failover may lose recent committed writes
B.Both methods universally guarantee no recent data loss because replication exists
C.Client retry behavior is unnecessary whenever the chosen method preserves committed data
D.Forced failover reconstructs deleted historical rows automatically

Show the answer and explanation

✓ Correct answer

A supported planned failover can synchronize before switching; forced asynchronous failover may lose recent committed writes

Synchronizing a planned transition differs from forcing an available async secondary when source changes may be missing. Neither operation inherently recovers pre-delete history. Connections can be interrupted even when committed writes survive. Source guide: PDF page 25,41.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.