Question: 12
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the
administrator of the company database.
Now you are in charge of a SQL Server 2008 instance. There is a database which is named Sellings in the
instance.
The Sellings database contains a table named Productions. The table is used to stores information about all types of products.
The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column
contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize
column.
According to the requirement of the company CIO, you have to optimize the query performance and reduce the
effect on the disk space to the least.
So what action should you perform to achieve this goal?
A. On the Products table, you should create a view.
B. On the RadioSize column, you should create a clustered index
C. On the RadioSize column, you should create a filtered index
D. On the RadioSize column, you should create a unique clustered index
Answer: C
Section: (none)
Explanation
Explanation/Reference:
A filtered index is an optimized nonclustered index, especially suited to cover queries that select from a welldefined
subset of data. It uses a filter predicate to index a portion of rows in the table. A well-designed filtered
index can improve query performance, reduce index maintenance costs, and reduce index storage costs
compared with full-table indexes.
Filtered indexes can provide the following advantages over full-table indexes:
Improved query performance and plan quality
Reduced index maintenance costs
Reduced index storage costs
Creating a filtered index can reduce disk storage for nonclustered indexes when a full-table index is not
necessary. You can replace a full-table nonclustered index with multiple filtered indexes without
significantly increasing the storage requirements.
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the
administrator of the company database.
Now you are in charge of a SQL Server 2008 instance. There is a database which is named Sellings in the
instance.
The Sellings database contains a table named Productions. The table is used to stores information about all types of products.
The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column
contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize
column.
According to the requirement of the company CIO, you have to optimize the query performance and reduce the
effect on the disk space to the least.
So what action should you perform to achieve this goal?
A. On the Products table, you should create a view.
B. On the RadioSize column, you should create a clustered index
C. On the RadioSize column, you should create a filtered index
D. On the RadioSize column, you should create a unique clustered index
Answer: C
Section: (none)
Explanation
Explanation/Reference:
A filtered index is an optimized nonclustered index, especially suited to cover queries that select from a welldefined
subset of data. It uses a filter predicate to index a portion of rows in the table. A well-designed filtered
index can improve query performance, reduce index maintenance costs, and reduce index storage costs
compared with full-table indexes.
Filtered indexes can provide the following advantages over full-table indexes:
Improved query performance and plan quality
Reduced index maintenance costs
Reduced index storage costs
Creating a filtered index can reduce disk storage for nonclustered indexes when a full-table index is not
necessary. You can replace a full-table nonclustered index with multiple filtered indexes without
significantly increasing the storage requirements.
