Microsoft
70-448 · Question #174
70-448 Question #174: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #174. The question stem and answer options stay visible for context.
Question
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. 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?
Exhibit
Options
- AFor each data flow a Sort transformation should be added.
- BIn each source component, the sorting properties should be updated
- CFor each data flow, an OLE DB Command transformationshould be added
- DYou should replace 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.