You are implementing the indexing strategy for a fact table in a data warehouse. The fact table is named Quotes.
The table has no indexes and consists of seven columns:
– [ID]
– [QuoteDate]
– [Open]
– [Close]
– [High]
– [Low]
– [Volume]
Each of the following queries must be able to use a columnstore index:
You need to ensure that the indexing strategy meets the requirements. The strategy must also minimize the number and size of the indexes.
What should you do?
A . Create one columnstore index that contains [ID], [Close], [High], [Low], [Volume] and [QuoteDate].
B . Create three coiumnstore indexes:
– One containing [QuoteDate] and [Close]
– One containing [QuoteDate], [High], and [Low]
– One containing [QuoteDate] and [Volume]
C . Create one columnstore index that contains [TradeDate], [Close], [High], [Low], and [Volume].
D . Create two columnstore indexes:
– One containing [ID], [QuoteDate], [Volume], and [Close]
– One containing [ID], [QuoteDate], [High], and [Low]
Answer: C