You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod that has a table named CK_Tbl that
keeps data about the entire catalogue of products. The users at Domain.com search CK_Tbl
which is based on the TestPro column. The TestPro column owns the NULL value for the entire
catalogue except products such as Televisions. However, there is no index on the TestPro column
presently. You have received instructions from management to ensure that queries are performed
more efficiently while minimizing the effect your solution will have on the disk space.
What should you do?
A.
You should consider developing a unique index on the TestPro column.
B.
You should consider developing a default index on the TestPro column.
C.
You should consider developing an un-cluttered index on the TestPro column.
D.
You should consider developing a filtered index on the TestPro column.