Provisioning SQL Databases — Question 37

You have Microsoft SQL Server on a Microsoft Azure virtual machine.
You discover that a database has 1,000 corrupt pages.
You need to repair the corrupt pages.
Which statement should you execute?

Answer options

• A. DBCC CHECKALLOC (REPAIR_REBUILD)
• B. DBCC CHECKDB WITH DATA_PURITY
• C. DBCC CHECKDB (REPAIR_ALLOW_DATA_LOSS)
• D. DBCC CHECKALLOC (REPAIR_FAST)

Correct answer: C

Explanation

The correct command is DBCC CHECKDB (REPAIR_ALLOW_DATA_LOSS) because it allows for the recovery of pages even at the cost of potentially losing some data. The other options either do not address the repair of corrupt pages or are less aggressive in their repair strategies, making them unsuitable for this situation.