You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. 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?

A.
You should use a Fuzzy Lookup transformation

B.
You should use a Lookup transformation along with the No cache option

C.
You should use a Lookup transformation along with the Full cache option

D.
You should use a Lookup transformation along with the Partial cache option