A SQL Database user deletes important rows. Regional replicas contain the same deletion. Which mechanism directly supports recovering the earlier state?

Choose the single best answer.

A.Disabling TDE to generate a historical row timeline
B.A forced failover that is guaranteed to exclude logical deletes
C.Restoring an arbitrary guest OS image of the SQL PaaS service
D.Native PITR to a retained pre-delete point, followed by validation and reconnection

Show the answer and explanation

✓ Correct answer

Native PITR to a retained pre-delete point, followed by validation and reconnection

PITR uses retained native SQL backups to recover an earlier/new database. Current replicas can contain the delete. SQL PaaS is not a guest VM backup target, and TDE does not generate deleted rows. Source guide: PDF page 38-39.

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.