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.

View Answer

Answer:

Explanation:

Step 1: Partition the table

Step 2: Create a partition function To migrate SQL Server partition definitions to SQL Data Warehouse simply: Eliminate the SQL Server partition scheme. Add the partition function definition to your CREATE TABLE.

Step 3: Create a partition scheme Partitioning requires a partition function and a partition scheme.

Step 4: Rebuild the clustered index Rebuild the clustered index onto new partition function/scheme.

References:

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-partition

https://blog.sqlrx.com/2017/02/24/sql-2016-partitioning-an-existing-table-with-a-columnstore-index/