Which four actions should you perform in sequence?

DRAG DROP
Your company has a data warehouse that contains all of the sales data for your company. Several business applications read data from the data warehouse.
You plan to deploy an indexing strategy for a 2-TB table named FactSales contains a clustered index.
You need to recommend a solution for index maintenance that meets the following requirements:
• Maintenance must be performed only when index fragmentation reaches 50 percent.
• Maintenance must minimize the impact on the database reads from the business applications.
Which four 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:

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.