Administering Microsoft SQL Server 2012/2014 Databases — Question 21

Which of the following SQL Server 2012 indexes stores data in a column-wise fashion instead of the traditional row-wise method?

Answer options

• A. Bitmap Index
• B. Clustered Index
• C. Function-based Index
• D. Columnstore Index

Correct answer: C

Explanation

The correct answer is C, as Function-based Indexes allow for the creation of indexes based on the result of a function applied to one or more columns. The other options, such as Bitmap Indexes and Clustered Indexes, do not store data in a column-wise format, and Columnstore Indexes, while column-oriented, are not the same as Function-based Indexes.