what sequence should you order four of the listed components for the data flow task?

DRAG DROP
You are creating a SQL Server Integration Services (SSIS) package to populate a fact table
from a source table. The fact table and source table are located in a Windows Azure SQL
Database. The source table has a price field and a tax field. The OLE DB source uses the
data access mode of Table.
You have the following requirements:
The fact table must populate a column named TotalCost that computes the sum of the price
and tax columns.
Before the sum is calculated, any records that have a price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools.
In what sequence should you order four of the listed components for the data flow task? (To
answer, move the appropriate components from the list of components to the answer area
and arrange them in the correct order.)

A.
Destinations load data into data stores or create in-memory datasets.
* The Conditional Split transformation can route data rows to different outputs depending on
the content of the data. The implementation of the Conditional Split transformation is similar
to a CASE decision structure in a programming language. The transformation evaluates
expressions, and based on the results, directs the data row to the specified output.
* The Derived Column transformation creates new column values by applying expressions to
transformation input columns. An expression can contain any combination of variables,
functions, operators, and columns from the transformation input. The result can be added as
a new column or inserted into an existing column as a replacement value.
QUESTION 56
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.

Explanation:

Box 1: OLE DB Source
Box 2: Conditional split
Box 3: Derived Column
Box 4: Ole DB Destination

Note:
* SQL Server Integration Services provides three different types of data flow components:
sources, transformations, and destinations. Sources extract data from data stores such as

tables and views in relational databases, files, and Analysis Services databases.
Transformations modify, summarize, and clean dat

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.