Microsoft
70-432 · Question #41
70-432 Question #41: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #41. The question stem and answer options stay visible for context.
Question
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?
Options
- AYou should restore the most recent backup of the History filegroup.
- BYou should restore the most recent backup of the History filegroup.
- CYou should backup the transaction log. Then restore the most recent backup of the PRIMARY
- DYou should backup the transaction log. Then restore the most recent backup of the History
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.