Exam DP-300 topic 7 question 10 discussion

Actual exam question from Microsoft's DP-300

Question #: 10
Topic #: 7

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.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: NOINDEX -
NOINDEX specifies that intensive checks of nonclustered indexes for user tables will not be performed. This choice decreases the overall execution time.
NOINDEX doesn't affect system tables because integrity checks are always performed on system table indexes.

Box 2: PHYSICAL_ONLY -
Many new checks have been introduced to include the new features.
Therefore, using the PHYSICAL_ONLY option may cause a much shorter run-time for DBCC CHECKDB on large databases and is recommended for frequent use on production systems.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15

by eric0718 at May 2, 2022, 2:24 a.m.

Comments

Submit Cancel

eric0718

Highly Voted 1 year, 7 months ago

Answer is correct: NOINDEX Specifies that intensive checks of nonclustered indexes for user tables will not be performed. This choice decreases the overall execution time. NOINDEX doesn't affect system tables because integrity checks are always performed on system table indexes. PHYSICAL_ONLY Limits the checking to the integrity of the physical structure of the page and record headers and the allocation consistency of the database. This check is designed to provide a small overhead check of the physical consistency of the database, but it can also detect torn pages, checksum failures, and common hardware failures that can compromise a user's data. https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15

upvoted 7 times

...

KIET2131

Most Recent 9 months, 3 weeks ago

NOINDEX EXTENDED_LOGICAL_CHECKS

upvoted 1 times

KIET2131

9 months, 3 weeks ago

sorry the second option is PHYSICAL_ONLY

upvoted 2 times

...