PrepAway - Latest Free Exam Questions & Answers

You need to restore the backup

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database
named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The
backup schedule is shown in the following table:

A drive fails and the CustomerOrders database goes into suspect mode on Tuesday at
09:00 hours.
You need to restore the backup.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Restore the backup taken on Sunday only.

B.
Restore the backups taken on Sunday and Monday.

C.
Restore the backup taken on Wednesday only.

D.
Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at
18:00 hours.

E.
Restore the backups taken on Wednesday and Thursday at 09:00 hours.

F.
Restore the backups taken on Wednesday, Thursday, and Friday.

G.
Restore the backups taken on Wednesday and Friday.

H.
Restore the backups taken Wednesday, Friday, and Saturday.


Leave a Reply