Microsoft
70-448 · Question #341
70-448 Question #341: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #341. The question stem and answer options stay visible for context.
Question
You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to upgrade a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package performs an extract, transform, and load (ETL) process for a sales data warehouse. You discover that the Lookup Transformation process runs slow. The package uses only OLE DB sources and destinations. You need to optimize the performance of the process that populates the Fact tables. What should you do?
Options
- AAdd a Fuzzy Lookup Transformation.
- BAdd an Import Column Transformation.
- CAdd a Raw File Source to populate the Lookup Transformation
- DAdd a Cache Transformation to populate the Lookup 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.