DRAG DROP
You administer a Windows Azure SQL Database database used for data warehouse operations.
The database contains a table named OrdersHistory, defined as follows:

A weekly ETL (extract-transform-load) runs a large INSERT statement to add data into the
OrdersHistory table. The process is taking a long time to complete. You discover that the bulk of the
process is performing non-clustered index updates on the OrdersHistory table.
You need to improve the performance of the ETL process faster. You need to meet the following
requirements:
Avoid losing existing permissions on existing objects.
Use minimal administrative effort.
What should you do? (To answer, move the appropriate actions from the list of actions to the
answer area and arrange them in the correct order.)

Answer:

Explanation: