You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance.
The SQL Server 2008 instance includes a database named ABC_DB, which also contains spatial
data types. You have received instructions to run a database consistency check on ABC_DB. The
process should allow for the inclusion of the spatial indexes, while also reducing the impact on the
database synchronization.
You are planning to make use of the DBCC CHECKDB Transact-SQL statement.
Which of the following arguments should be included in the Transact-SQL statement?
A.
NOINDEX
B.
EXTENDED_LOGICAL_CHECKS
C.
ESTIMATEONLY
D.
DATA_PURITY
Explanation: