Study tips 70-463

You need to design a solution that meets these requirements

You need to define and reuse the connection managers in all the packages by using the least development effort

Which Data Flow transformation should you use?

You need to ensure that all the execution trees run in parallel

You need to use the least amount of administrative effort to achieve this goal

You need to configure the Fuzzy Lookup transformation in the most efficient manner

Which data flow transformation should you use?

You need to run an update statement against the table

You need to define and reuse the Excel file connection in all project packages

Which Data Flow transformation should you use?