Which of the following SQL Server 2012 indexes stores data in a column-wise fashion instead of the traditional row-wise method?
A. Bitmap Index
B. Clustered Index
C. Function-based Index
D. Columnstore Index
Which of the following SQL Server 2012 indexes stores data in a column-wise fashion instead of the traditional row-wise method?
A. Bitmap Index
B. Clustered Index
C. Function-based Index
D. Columnstore Index
Answer: D. Columnstore Index
An xVelocity memory optimized columnstore index, groups and stores data for each column and then joins all the columns to complete the whole index. This differs from traditional indexes which group and store data for each row and then join all the rows to complete the whole index.
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/gg492088(v=sql.110)