Quiz 70-458

Quiz 70-458, Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2

Which hierarchy type should you use?

You need to complete the post-installation configuration

You need to produce the CSV file with the least amount of development effort

You need to ensure that the indexing strategy meets the requirements

You need to design a solution that can join a single time dimension to both fact tables

Which three steps should you perform in sequence?

How should you design the control flow for the package?

Which four actions should you perform in sequence by using SQL Server Management Studio?

How should you design the data flow outputs?

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