Exam 70-765 All Questions

View all questions & answers for the 70-765 exam

Exam 70-765 topic 3 question 98 discussion

Actual exam question from Microsoft's 70-765

Question #: 98
Topic #: 3

You have a database named DB1 that uses simple recovery mode.
Full backups of DB1 are taken daily and DB1 is checked for corruption before each backup.
There was no corruption when the last backup was complete.
You run the sys.columns catalog view and discover corrupt pages.
You need to recover the database. The solution must minimize data loss.
What should you do?

A. Run RESTORE DATABASE WITH RECOVERY.
B. Run RESTORE DATABASE WITH PAGE.
C. Run DBCC CHECKDB and specify the REPAIR_ALLOW_DATA_LOSS parameter.
D. Run DBCC CHECKDB and specify the REPAIT_REBUILD parameter.

Show Suggested Answer

Suggested Answer: B 🗳️
Expalantion:
A page restore is intended for repairing isolated damaged pages. Restoring and recovering a few individual pages might be faster than a file restore, reducing the amount of data that is offline during a restore operation.

RESTORE DATABASE WITH PAGE -
Restores individual pages. Page restore is available only under the full and bulk-logged recovery models.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql

by t at March 28, 2019, 6 p.m.

Comments

Submit Cancel

Varad

Highly Voted 5 years, 8 months ago

Answer should be "D" . https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15

upvoted 6 times

...

munro1900

Most Recent 4 years, 5 months ago

Since when do you see corrupt pages within the sys.columns catalog? This question is so wrong ... A. restore database with recovery puts a database into a recovered state and is redundant for a full backup restore because it is implied by the full restore; B. will not work because of simple rec model C. last option ever, all it does is remove corrupt pages D. rarely ever fixes corruption Normally you would go like this: checkdb to see extend of corruption, estimate how much data was added from the last backup, try a checkdb with repair_rebuild in an uncommitted transaction, pray for nothing, do the restore from full backup. :))

upvoted 1 times

...

da

4 years, 8 months ago

i think, it should be D as well.

upvoted 1 times

...

KC

5 years ago

I think the answer is restore with recovery. The last backup had no corruption, so it would be most straightforward solution. Since it’s a simple recovery model, I don’t think the transaction log would be used for recovery anyway. It doesn’t appear that Microsoft recommends repair options, unless the backups are also corrupt.

upvoted 4 times

RohitRaj2311

4 years, 8 months ago

That is why D option is correct as it does not cause data loss.

upvoted 1 times

...

ballanor

4 years, 5 months ago

I agree with this. If the database is in simple backup the Admin is accepting that there may be data loss in the event of a recovery. Microsoft recommends using DBCC repair/rebuild only if backups are corrupted as well.

upvoted 1 times

...

norbert1

5 years, 4 months ago

hi, page restore really does not work with simple rec. model.. and in general all you read is - restore bevore repair! --> so, why not with recovery (which only means --> put in useable state..)

upvoted 2 times

...

Varad

5 years, 8 months ago

Using REPAIR_ALLOW_DATA_LOSS parameter. there is a possibility of losing more data

upvoted 1 times

...

t

6 years, 3 months ago

if page restore is only available under full or bulk logged recovery and this database is set to simple, how is this the correct answer?

upvoted 2 times

STH

5 years, 9 months ago

Since REPAIR_REBUILD does not lead to data loss it could be the prefered option. But it also could be inefficient. The RESTORE full database operation will works in any case but also can leads to data loss, so it should be use in case of REPAIR is not enough

upvoted 2 times

...