Microsoft
70-448 · Question #105
70-448 Question #105: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #105. The question stem and answer options stay visible for context.
Question
You are creating a SQL Server 2008 Integration Services (SSIS) data flow which gets information from two sources for Company.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. Every source database is belongs to a different server and based on a SELECT statement which utilizes an ORDER BY clause. The data flow is listed below: You get error message below when you connect the paths from the two sources "Data Flow Task: The input is not sorted. The 'input "Merge Join Left Input" (80)' must be sorted." You should make sure that data from every search is contained in every row in the data flow. In order to solve the problem, which is the correct answer?
Options
- AYou should increase a Lookup transformation for some data flows.
- BYou should increase a Lookup transformation for every data flow.
- CYou should refresh the sorting properties in each source component.
- DYou should choose a default 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.