<< Prev Question Next Question >>
Question 21/55
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:
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:
