• Description: Microsoft SQL Server 2008, Business Intelligence Development and
• Passing Score: 0%
• Practice Test - Number of questions: 100 questions
• Simulation Test - Number of questions: 100 questions
• Simulation Test Duration: 120 minutes
• Has explanations: No

You are creating a SQL Server 2008 Integration Services (SSIS) instance which contains a Data Flow task which reproduces some million rows for Company.com. The data flow asks a match against a reference table which includes 50,000 rows including every row would be utilized during the data flow in the reference table. You should make sure that the data flow runs least time. Which is the correct answer?

Answer(s)

1. You should choose a Lookup transformation along with the half cache option
2. You should choose a Lookup transformation along with the Full cache option
3. You should choose a default Lookup transformation
4. You should choose a Lookup transformation along with the Default cache option

You should choose a Lookup transformation along with the Full cache option