A Basic Azure SQL Database must recover a mistakenly deleted row from twenty days ago. No other retained copy exists. What design gap prevents the proposed native PITR approach?

Choose the single best answer.

A.Geo-replication automatically retains each historical row for thirty-five days
B.Every SQL Database tier has an unconditional ten-year PITR timeline
C.Basic short-term retention is limited to one through seven days, so the desired point exceeds that window
D.TDE prevents all restores older than twenty-four hours

Show the answer and explanation

✓ Correct answer

Basic short-term retention is limited to one through seven days, so the desired point exceeds that window

The guide limits Basic PITR retention to one-seven days. TDE does not impose the stated age limit. Geo-replication copies current changes, and ten-year LTR is selected backups rather than a ten-year PITR timeline. 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.