PrepAway - Latest Free Exam Questions & Answers

You need to restore the database by ensuring minimal data loss in minimum possible time

You maintain a SQL Server 2008 instance that contains a database named Finance.
The Finance database contains the following filegroups:
The PRIMARY filegroup that contains the On-Line Transaction Processing (OLTP) data
stored in the F: volume.
A filegroup named Histoiy that contains historical data stored in the G: volume.
The transaction log of the database is stored in the H: volume.
As part of the archiving strategy for the Finance database, data is frequently moved from the
PRIMARY filegroup to the History filegroup.
The backup strategy for the Finance database consists of the following requirements:
Backing up the PRIMARY filegroup five times a day
Backing up the History filegroup at the end of each working day
Backing up the transaction log every 15 minutes
At 13:00 hours, the volume that contains the History filegroup fails.
You need to restore the database by ensuring minimal data loss in minimum possible time.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Restore the most recent backup of the History filegroup.

B.
Restore the most recent backup of the History filegroup. Restore all the transaction log
backups after the most recent backup of the History filegroup.

C.
Backup the transaction log. Restore the most recent backup of the History filegroup.
Restore all the transaction log backups after the most recent backup of the History filegroup.

D.
Backup the transaction log. Restore the most recent backup of the PRIMARY filegroup.
Restore the most recent backup of the History filegroup. Restore all the transaction log
backups after the most recent backup of the History filegroup.


Leave a Reply