Quiz 70-463

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

How should you design the control flow for the package?

Which package configuration should you use?

Which three steps should you perform in sequence?

Which query should you use as the data source?

Which order should you use?

Which event handler should you use?

You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their changes

What should you select from the SSIS Toolbox?

Which four actions should you perform in sequence?

You need to add a task or component to the package that allows you to implement the SCD logic