Microsoft
70-457 · Question #83
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
(55 responses)- A75% (41)
- B7% (4)
- C4% (2)
- D15% (8)
Community Discussion
No community discussion yet for this question.