1Z0-515 Question #37: Real Exam Question with Answer & Explanation

The correct answer is A. Bitmap indexes. Bitmap indexes are a highly compressed index type that tends to be used primarily for data Characteristic of Bitmap Indexes For columns with very few unique values (low cardinality) Columns that have low cardinality are good candidates (if the cardinality of a column is <= 0.1 %

Question

You will be implementing a data warehouse for one of your customers. In your design process, which index type is most likely to be used to improve the performance of some queries where the data is of low cardinality?

Options

ABitmap indexes
BB*-tree indexes
CReverse indexes
DInvisible indexes

Explanation

Bitmap indexes are a highly compressed index type that tends to be used primarily for data Characteristic of Bitmap Indexes * For columns with very few unique values (low cardinality) * Columns that have low cardinality are good candidates (if the cardinality of a column is <= 0.1 % that the column is ideal candidate, consider also 0.2% - 1%) * Tables that have no or little insert/update are good candidates (static data in warehouse) * Stream of bits: each bit relates to a column value in a single row of table

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice