Microsoft
70-450 · Question #105
70-450 Question #105: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #105. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 Enterprise Edition instance that hosts a large database. The database uses the simple-recovery model. The database contains the following three additional filegroups: - FileGroupA that is read/write - FileGroupB that is read-only - FileGroupC that is read-only FilegroupB contains less critical data than FilegroupC. You discover that the PRIMARY filegroup and FileGroupB have failed. You need to recover the database in the minimum possible time. You also need to ensure that data is available as soon as possible. What should you do?
Options
- APerform a full database restore.
- BPerform a partial restore of the PRIMARY filegroup and FileGroupB from a partial backup.
- CPerform a partial restore of the PRIMARY filegroup and FileGroupA from a partial backup.
- DPerform a partial restore of the PRIMARY filegroup and FileGroupA from a partial backup.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 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.