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.
Respectfully disagree, I think PHYSICAL_ONLY is the right call here. NOINDEX and PHYSICAL_ONLY together really cut execution time for huge DBs by skipping logical checks and nonclustered indexes. DATA_PURITY is a trap if speed's the concern. Thoughts?
NOINDEX and PHYSICAL_ONLY. These both target performance for big DBs by cutting out the deep data checks (PHYSICAL_ONLY) and avoid scanning nonclustered indexes (NOINDEX). Unless the question wanted full logical checks, this combo is much quicker, especially at 50 TB. If someone thinks DATA_PURITY matters more here, let me know but pretty sure this is right.
