Microsoft Technology Associate Mta · Free Practice Question Medium
Question 7
You manage a database named Customers, which includes a table named Orders. The Orders table is frequently queried, but only orders with a sales total of more than $1000.00 are required in the query.
You want to create an index to speed up these types of queries at the same time, ensuring the index is as small as possible.
What type of index should you use?
-
A
Non-clustered index
-
B
XML
-
C
Clustered index
-
D
Filtered index
Reveal correct answer
Correct answer: D
Explanation
Filtered indexes are nonclustered indexes that have the addition of a WHERE clause. Filtered indexes provide notable improvements over a traditional nonclustered index. This allows the index to target specific data values – only records where the conditions are satisfied, will be added to the index – resulting in a much smaller, more accurate, and more efficient index. A well-designed filtered index can improve query performance as well as reduce index maintenance and storage costs compared with full-table indexes.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
