A SQL failover-group secondary contains a mistaken delete performed an hour earlier. Which recovery action should be evaluated?

Choose the single best answer.

A.Rotate the TDE key to reconstruct the deleted records
B.Restore a retained backup/PITR point from before the delete and validate/reconnect the application
C.Force failover because replication always excludes accidental deletes
D.Add a read-scale replica to recover prior versions automatically

Show the answer and explanation

✓ Correct answer

Restore a retained backup/PITR point from before the delete and validate/reconnect the application

A pre-error retained point can recover good data. Geo/current read replicas can carry the delete and do not supply history. Key rotation changes cryptographic control rather than recreating records. Source guide: PDF page 25.

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.