DRAG DROP
You administer a database that is used for reporting purposes. The database has a large fact table that
contains three hundred million rows. The table includes a clustered columnstore index and a nonclustered
index on the ProductID column. New rows are inserted into the table every day.Performance of queries that filter the Product ID column have degraded significantly.
You need to improve the performance of the queries.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.
Select and Place:
Answer: 
Explanation:
Step 1: Drop the clustered columnstore index
Step 2: Create a clustered rowstore index on ProductID.
Rowstore indexes perform best on queries that seek into the data, searching for a particular value, or for
queries on a small range of values. Use rowstore indexes with transactional workloads since they tend to
require mostly table seeks instead of table scans.
Step 3: Create a nonclustered index on ProductID
Incorrect Answers:
Not: Create a nonclustered columnstore index on ProductID
Use a nonclustered columnstore index to perform analysis in real-time on an OLTP workload.
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview