Microsoft
70-432 · Question #96
You are the administrator of a SQL Server 2008 instance with a database named Sales. The Sales database has a table named Products that stores information about all types of products. Users…
The correct answer is A. Create a filtered index on the TelevisionSize column. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named Sales. The Sales database has a table named Products that stores information about all types of products. Users frequently query the Products table based on the TelevisionSize column. The TelevisionSize column has the NULL value for all products other than Televisions. There is currently no index on the TelevisionSize column. You need to improve the query performance by ensuring that the effect on the disk space is minimized. What should you do?
Options
- ACreate a filtered index on the TelevisionSize column.
- BCreate a clustered index on the TelevisionSize column.
- CCreate a unique clustered index on the TelevisionSize column.
- DCreate a view on the Products table by filtering on the TelevisionSize column.
How the community answered
(33 responses)- A85% (28)
- B3% (1)
- C3% (1)
- D9% (3)
Community Discussion
No community discussion yet for this question.