Microsoft
70-448 · Question #283
70-448 Question #283: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #283. The question stem and answer options stay visible for context.
Question
You are developing a SQL Server 2008 Integration Services (SSIS) data flow that 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. The data flow is as shown in the following diagram. When the paths from the two sources are connected to a Merge Join component, the following error message is displayed: "Data Flow Task: The input is not sorted. The 'input "Merge Join Left Input" (80)' must be sorted." You need to ensure that data from each query is included in each row in the data flow. You want to achieve this goal by using minimum amount of execution time. What should you do?
Exhibit
Options
- AAdd a Sort transformation for each data flow.
- BAdd an OLE DB Command transformation for each data flow.
- CUpdate the sorting properties in each source component.
- DReplace the Merge Join transformation with a Union All transformation.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.