Microsoft
70-448 · Question #173
70-448 Question #173: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #173. 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're desinging a SQL Server 2008 Integration Services (SSIS) package. The package contains a Data Flow task which copies several million rows. There is a reference table that contains 10,000 rows. The data flow needs a match against the reference table. During the data flow, each row in the reference table will be used. You must make sure that the data flow takes as little time to execute as possible. Of the following data flow components, which one should you use?
Options
- AYou should use a Fuzzy Lookup transformation
- BYou should use a Lookup transformation along with the No cache option
- CYou should use a Lookup transformation along with the Full cache option
- DYou should use a 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.