nerdexam
Microsoft

70-458 · Question #96

70-458 Question #96: 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

70-458 question #96 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.

Full 70-458 Practice