Study tips 70-463

You need to design the software title dimension

You need to design a table structure to ensure that certain users can see sales data for only certain districts

You need to redesign the dimension to enable the full historical reporting of changes to multiple customer attributes including Postcode

You need to ensure that the indexing strategy meets the requirements

You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented

You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort

You need to ensure that the project is deployed to the SSIS catalog on the production server

You need to ensure that the custom component is deployed on a test environment correctly

Which three actions should you perform in sequence?

What should you use to execute the package?