You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support.
According to the requirement of the company, you are developing a SQL Server 2008
Integration Services (SSIS) data flow. The data flow extracts data from two sources. Each
source database is located on a different server. Each source is based on a SELECT
statement that uses an ORDER BY clause. Each source is based on a SELECT statement.
An ORDER BY clause is used by the statement. The following diagram presents the data
flow. The following error message pops up when the paths from the two sources are
connected to a Merge Join component. “Data Flow Task: The input is not sorted.
The ‘input “Merge Join Left Input” (80)’ must be sorted.”
You must make sure that data from each query is included in each row in the data flow. You
must achieve this goal by using as little execution time as possible.
So what action should you perform?

A.
For each data flow a Sort transformation should be added.

B.
In each source component, the sorting properties should be updated

C.
For each data flow, an OLE DB Command transformationshould be added

D.
You should replace the Merge Join transformation with a Union All transformation