You work as a Database Administrator (DBA) for a company named ABC.com. The
company has a Windows Azure subscription. The company uses a cloud-based SQL
Server environment hosted on SQL Azure.
You are using SQL Server Data Tools to create a SQL Server Integration Services (SSIS)
package. The package will use data from a source table to populate a fact table. You have
configured Table as the data access mode for the OLE DB source.

The fact table has a column named TotalSales. The source table has two columns named
CompletedSales and ConfirmedOrders.
You need to configure the SSIS package to discard any records with zero values in the
CompletedSales and ConfirmedOrders columns then populate the TotalSales column in the
fact table with the sum values of the CompletedSales and ConfirmedOrders columns.
How should you configure the data flow task?

A.
Configure a Copy Column then a Conditional Split then a Data Profiling Task then a Data
Conversion.

B.
Configure a Derived Column then a Data Profiling Task then a Conditional Split then an OLE
DB Source.

C.
Configure a Derived Column then a Data Profiling Task then a Conditional Split then an OLE
DB Destination

D.
Configure a Derived Column then a Data Profiling Task then a Conditional Split then a Copy
Column.

Explanation: