Exam 70-765 topic 3 question 98 discussion

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

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. :))

i think, it should be D as well.

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.

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..)

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

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?