You need to add the most efficient index to support the…

Note: The question is part of a series of questions that use the same or similar answer choices. An answer
choice may be correct for more than one question in the series. Each question is independent of the other
question in the series. Information and details provided in a question apply only to that question.
You have a database named DB1. The database does not have a memory optimized filegroup.
You create a table by running the following Transact-SQL statement:

The table is currently used for OLTP workloads. The analytics user group needs to perform real-time
operational analytics that scan most of the records in the table to aggregate on a number of columns.You need to add the most efficient index to support the analytics workload without changing the OLTP
application.
What should you do?

A.
Create a clustered indexon the table.

B.
Create a nonclustered index on the table.

C.
Create a nonclustered filtered index on the table.

D.
Create a clustered columnstore index on the table.

E.
Create a nonclustered columnstore index on the table.

F.
Create a hash index on the table.

Explanation:
A nonclustered columnstore index enables real-time operational analytics in which the OLTP workload uses the
underlying clustered index, while analytics run concurrently on the columnstore index.
Columnstore indexes can achieve up to 100xbetter performance on analytics and data warehousing workloads
and up to 10x better data compression than traditional rowstore indexes. These recommendations will help your
queries achieve the very fast query performance that columnstore indexes are designed to provide.
https://msdn.microsoft.com/en-us/library/gg492088.aspx