Microsoft
70-457 · Question #83
70-457 Question #83: Real Exam Question with Answer & Explanation
The correct answer is A. Perform a file restore.. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following table. You discover that Sales_2.ndf is corrupt. You need to recover the corrupted data in the minimum amount of time. What should you do?
Exhibit
Options
- APerform a file restore.
- BPerform a transaction log restore.
- CPerform a restore from a full backup.
- DPerform a filegroup restore.
Community Discussion
No community discussion yet for this question.