Exam 70-765 topic 3 question 29 discussion

Actual exam question from Microsoft's 70-765

Question #: 29
Topic #: 3

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.

Show Suggested Answer

Suggested Answer: A 🗳️
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

by RohitM at Oct. 8, 2019, 8:49 a.m.

Comments

Submit Cancel

rohithravindran

4 years, 8 months ago

correct answer is C : Perform a restore from a full backup

upvoted 1 times

...

msamm

5 years, 5 months ago

The file restore could be a valid answer here. Reason being that the database is of 3TB and we need to make it workable in minimum time possible. It may be possible that the file that is corrupted is the smallest one. SInce this database has 2 Archive files, they might be taking up major portion of the 3TB. So logic says why waste time on restoring the entire DB when you can restore 1 file and get up and running. This is a situational question to which the right or wrong answer can be determined by the exact sizes of the individual files. But without them, just on the face file restore seems a better option.

upvoted 4 times

Tabz

5 years, 2 months ago

The correct answer should be restore from full backup. If a single file was lost then yes a file level restore makes sense however, the question states that all files except sales_2.ndf are corrupt which means only sales_2.ndf is good and in this scenario I would go for a restore from full backup as well

upvoted 4 times

...

Varad

5 years, 7 months ago

I agree. "Option C. Perform a restore from a full backup." is th right answer

upvoted 2 times

...

RohitM

5 years, 8 months ago

Correct Answer should be C. in the scenario all the files are corrupt except 1. Full backup restore will be beneficial in this case than file restore.

upvoted 4 times

KC

5 years ago

Agreed. I don’t think a file backup is supported for a read/write db... “Under the simple recovery model, file backups are supported only for read-only files. The primary filegroup and read/write secondary filegroups are always restored together, by restoring a database or partial backup.”

upvoted 1 times

KC

5 years ago

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/file-restores-simple-recovery-model?view=sql-server-ver15

upvoted 1 times

...