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

For a 50-TB database, performance is the primary constraint. PHYSICAL_ONLY significantly reduces execution time by limiting checks to the integrity of the physical structure (page headers and allocation) and avoiding expensive logical consistency checks on data and metadata. It skips checking column values and computed columns.

The NOINDEX option further optimizes performance by instructing DBCC CHECKDB to skip intensive logical checks of non-clustered indexes for user tables. Since non-clustered indexes are redundant structures, their exclusion prioritizes the integrity of the base data (heaps or clustered indexes) while drastically reducing the I/O and CPU overhead required for the consistency check process.

Official Microsoft Documentation: "DBCC CHECKDB (Transact-SQL)" – Sections: PHYSICAL_ONLY and NOINDEX Arguments. [Microsoft Learn]

Official Microsoft Documentation: "Optimizing DBCC CHECKDB performance" – Best practices for large databases. [Microsoft Learn]

Academic Reference: Database Systems: The Complete Book, 2nd Edition (Garcia-Molina, Ullman, Widom) – Chapter on Recovery and Integrity Management (Page 894 regarding physical vs. logical consistency).

Official Microsoft Documentation: "Troubleshoot DBCC CHECKDB performance" – Identifier: 2024-SQL-MNT.