Microsoft
70-458 · Question #67
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 all files except…
The correct answer is A. Perform a restore from a full backup. 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 all files except Sales_2.ndf are corrupt. You need to recover the corrupted data in the minimum amount of time. What should you do?
Exhibit
Options
- APerform a restore from a full backup.
- BPerform a transaction log restore.
- CPerform a file restore.
- DPerform a filegroup restore.
How the community answered
(46 responses)- A85% (39)
- B2% (1)
- C4% (2)
- D9% (4)
Community Discussion
No community discussion yet for this question.