DP-300 Certification Practice Question #269

Question

You have a 50-TB Microsoft SQL Server database named DB1.
You need to reduce the time it takes to perform database consistency checks of DB1.
Which Transact-SQL command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To minimize the time required to perform consistency checks on a 50-TB database (a very large database), you should bypass the most resource-intensive checks. Specifying `NOINDEX` skips the consistency checks of non-clustered indexes. Specifying `PHYSICAL_ONLY` limits the checks to physical integrity (torn pages, checksums, and header structures), skipping logical consistency checks. Together, these options provide the fastest possible execution time for database consistency checks.

More DP-300 practice questions