Microsoft Exam Questions

You need to recover the corrupted data in the minimum amount of time

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 exceptSales_2.ndf are corrupt. You need to recover the corrupted data in the
minimum amount of time. What should you do?

A.
Perform a restore from a full backup.

B.
Perform a transaction log restore.

C.
Perform a file restore.

D.
Perform a filegroup restore.