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 nonclusteredindex 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.

View Answer

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.

References: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview