A SQL Database must retain selected full backups for seven years for compliance. Its operational PITR window is thirty-five days. Which recommendation meets the distinct retention need?

Choose the single best answer.

A.Rely on a read-only replica as immutable backup history
B.Configure supported long-term retention in addition to short-term PITR
C.Use a failover group as a seven-year historical backup store
D.Increase PITR to seven years because all short-term windows permit it

Show the answer and explanation

✓ Correct answer

Configure supported long-term retention in addition to short-term PITR

LTR supports selected backups up to ten years, separate from short-term PITR. Current replicas/failover groups maintain current state rather than years of independent historical backups, and ordinary PITR does not span seven years. Source guide: PDF page 38.

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.