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_Prod.

The CK_Prod contains the following file groups:
* The PRIMARY file group that contains the On-Line Transaction Processing (OLTP) information that is kept in the reserved in the E: volume.
* A file group named CK_USERS that contains the older information that is kept in the F: volume.
* A transaction log of the information that is kept in the I: volume.

Data transferring occurs from the PRIMARY file group to CK_USERS, as a member of the archiving strategy for CK_Prod.
The backup of CK_Prod is as follows:
* The PRIMARY file group six times a day.
* The CK_USERS at 20:00
* The transaction log every 20 minutes

However, the volume that contains CK_USERS was lost at 14:00 hours. You have received
instructions to perform a recovery of CK_USERS with minimal data loss and in the shortest time as possible.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider backing up the transaction log and recovery the latest backup of
CK_USERS and recovery the entire transaction log backups after the most resent backup.

B.
You should consider backing up the transaction log and recovery the oldest backup of
CK_USERS and recovery the entire transaction log backups after the most resent backup.

C.
You should consider recovering the oldest backup of CK_USERS.

D.
You should consider recovering the latest backup of CK_USERS.


Leave a Reply