Our PDF dumps of 70-432 exam is designed to ensure everything which you need to pass your exam successfully. At GreatExam, we have a completely customer oriented policy. We invite the professionals who have rich experience and expert knowledge of the IT certification industry to guarantee the PDF details precisely and logically. Our customers’ time is a precious concern for us. This requires us to provide you the products that can be utilized most efficiently.
QUESTION 41
You are the administrator of a SQL Server 2008 instance with a database named DB1.
DB1 has two filegroups: one is a filegroup named History that contains historical data stored in the G: volume; the other is the PRIMARY filegroup that contains the On-Line Transaction Processing (OLTP) data stored in the F: volume.
The backup strategy of DB1 has three requirements:
– first, the History filegroup should be backed up at the end of each working day;
– second, the PRIMARY filegroup should be backed up five times a day;
– third, the transaction log should be backed up every quarter.
You get a report at 13:00 saying that the volume which contains the History filegroup fails.
As the technical support, you have to restore the database, and you must reduce the data loss to the least as soon as possible.
What should you do?
A. You should restore the most recent backup of the History filegroup.
B. You should 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. You should backup the transaction log. Then restore the most recent backup of the PRIMARY filegroup and restore the most recent backup of the History filegroup. After the most recent backup of the History filegroup, restore all the transaction log backups
D. You should backup the transaction log. Then restore the most recent backup of the History filegroup and restore all the transaction log backups after the most recent backup of the History filegroup.