Microsoft
70-448 · Question #329
70-448 Question #329: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #329. The question stem and answer options stay visible for context.
Question
You are designing a SQL Server 2008 Integration Services (SSIS) package. The package includes a Data Flow task that copies several million rows. The data flow requires a match against a reference table that contains 10,000 rows. Each row in the reference table will be used during the data flow. You need to ensure that the data flow executes in the minimum amount of time. Which data flow component should you select?
Options
- Aa Fuzzy Lookup transformation
- Ba Lookup transformation along with the Full cache option
- Ca Lookup transformation along with the No cache option
- Da Lookup transformation along with the Partial cache option
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.