You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. CK_DB also contains spatial data types.
You have received instructions to run a database consistency check on CK_DB to hold the spatial
indexes and to make the effect on the database concurrency minimized.
What should you do?
A.
You should consider running the following:
DBCC CHECKDB (CK_DB) WITH VIEWDELETE;
B.
You should consider running the following:
DBCC CHECKDB (CK_DB) WITH EXTENDED_LOGICAL_CHECKS;
C.
You should consider running the following:
DBCC INDEXDEFRAG(CK_DB)
D.
You should consider running the following:
DBCC SHRINKFILE(CK_DB)