DP-300 Certification Practice Question #271

Question

You have a SQL Server on Azure Virtual Machines instance that hosts a 10-TB SQL database named DB1.
You need to identify and repair any physical or logical corruption in DB1. The solution must meet the following requirements:
✑ Minimize how long it takes to complete the procedure.
✑ Minimize data loss.
How should you complete the command? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To check and repair both physical and logical corruption while minimizing data loss, `REPAIR_REBUILD` is the correct option. It repairs minor issues like index corruption with no risk of data loss. To minimize the duration of the consistency checks on a large 10-TB database, the `TABLOCK` option should be specified. `TABLOCK` skips database snapshot creation and locks the tables directly, resulting in faster execution. `PHYSICAL_ONLY` cannot be used because it skips logical checks, violating the core requirement to find both physical and logical corruption.

More DP-300 practice questions