You are designing a new database table that will be used for reporting.
You define the table by using the following statement.
You need to store the data in the table by using the least amount of storage space possible.
Which storage option should you use?
A.
a clustered index
B.
a clustered columnstore index
C.
a nonclustered index
D.
In-Memory OLTP
Explanation:
Columnstore indexes work well for mostly read-only queries that perform analysis on large data sets. This
would fit this scenario as the table will be used for reporting.
Columnstore Index benefits include Columnstore Index benefits high compression rates, which improve query
performance by using a smaller in-memory footprint. In turn, query performance can improve because SQL
Server can perform more query and data operations in-memory.
Use the columnstore index to achieve up to 10x query performance gains over traditional row-oriented storage,
and up to 7x data compression over the uncompressed data size.
https://msdn.microsoft.com/en-us/library/gg492088(v=sql.120).aspx