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 contains a table named CK_Prod
that contains several indexes and numerous rows. However, 40 % of the indexes on CK_DB are
fragmented. You have received instructions to ensure that the effect on database availability is
minimized.
What should you do?
A.
You should consider using the Full index option.
B.
You should consider using the Page index option.
C.
You should consider using the Online option.
D.
You should consider using the Offline option.