DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package to add a large
amount of data to a fact table named factOrders. The factOrders table is partitioned by week
and has a clustered index.
You need to load three weeks’ data into the factOrders table by using the most efficient
method.
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.
Answer: See the explanation
Explanation:
Box 1:Box 2:
Box 3:
Note:
* Need temporary tables.
* Can load data into the temporary tables in parallel
* ALTER TABLE
/ SWITCH
SWITCH [ PARTITION source_partition_number_expression ] TO [ schema_name. ]
target_table [ PARTITION target_ partition_number_expression ]
Switches a block of data in one of the following ways:
Reassigns all data of a table as a partition to an already-existing partitioned table.
Switches a partition from one partitioned table to another.
Reassigns all data in one partition of a partitioned table to an existing non-partitioned table.
