DP-300 Certification Practice Question #264

Question

You have SQL Server on an Azure virtual machine that contains a database named DB1.
The database reports a CHECKSUM error.
You need to recover the database.
How should you complete the statements? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To repair structural or allocation errors (such as a database CHECKSUM error) using `DBCC CHECKDB`, the database must first be set to `SINGLE_USER` mode to prevent other processes from accessing the database during repair. The actual repair command must specify a repair level; since `REPAIR_FAST` is obsolete and does nothing, and no other repair levels are available in the dropdown, `REPAIR_ALLOW_DATA_LOSS` is the correct parameter to repair allocation errors. Finally, the database must be returned to `MULTI_USER` mode to resume normal operations.

More DP-300 practice questions