What should you do?
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?
A . Perform a file restore.
B . Perform a transaction log restore.
C . Perform a restore from a full backup.
D . Perform a filegroup restore.
Answer: A
Explanation:
In a file restore, the goal is to restore one or more damaged files without restoring the whole database.
References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/file-restores-simple-recovery-model
Latest 70-765 Dumps Valid Version with 243 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund