Quiz 70-463

Quiz 70-463, Implementing a Data Warehouse with Microsoft SQL Server 2012

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

You need to design the implementation strategy to meet the requirements while minimizing development and deployment effort and maximizing data flow performance

Which three actions should you perform in sequence?