Microsoft
70-458 · Question #96
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…
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.
How the community answered
(27 responses)- A78% (21)
- B7% (2)
- C11% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.