Which three actions should you perform in sequence?

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:

Correct Answer:

Explanation/Reference:
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.
References: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview