A SQL native backup plan has a full baseline, a later differential, and several transaction logs. One required log segment is missing. What is the correct recovery consideration?

Choose the single best answer.

A.Only the newest VM snapshot proves every selected-time database restore is possible
B.Differential backups contain every change since the last log regardless of baseline
C.Any later log can always be applied directly to an empty database
D.Restore precision depends on a valid applicable baseline/differential/log chain; a missing required segment can limit the target time

Show the answer and explanation

✓ Correct answer

Restore precision depends on a valid applicable baseline/differential/log chain; a missing required segment can limit the target time

A valid chain determines reachable points. Logs require the proper database chain rather than an empty baseline; a differential relates to its full baseline. VM snapshots are different from proving SQL log continuity. Source guide: PDF page 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.