PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. The backup of CK_DB is as follows:
* Full backup at 13:00
* Differential backup at 15:00
* Database snapshots at 20:00 and 21:00

Furthermore, the backups and the database snapshots are reserved on a different disk. However,
CK_DB has failed at 18:30. You have received instruction to recover CK_DB with the minimal
amount of data loss.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider recovering the Differential backup files only.

B.
You should consider recovering the Full backup and the differential backup files.

C.
You should consider recovering the Full backup files only.

D.
You should consider recovering the database snapshot from 21:00.

E.
You should consider recovering the database snapshot from 20:00.


Leave a Reply