SQL Server on an Azure VM needs selected-time recovery with no more than fifteen minutes of lost updates under the backup design. Which two measures should be planned? Select 2 answers.

Select all that apply. Every correct option and no extras are required for credit in the app.

A.Only a weekly OS-disk snapshot without database logs
B.Use read-scale replica routing as proof every historical restore time exists
C.Frequent successful log backups and a valid restorable log chain matching the required RPO
D.Supported workload-aware full/differential/log backups or a correctly operated native SQL plan

Show the answer and explanation

✓ Correct answers

Frequent successful log backups and a valid restorable log chain matching the required RPO
Supported workload-aware full/differential/log backups or a correctly operated native SQL plan

Baseline/differential/log chains enable workload-aware selected-time restore; frequent successful logs support the intended gap. An OS snapshot excludes the precise chain, and routing reports to replicas provides no historical timeline. 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.