QUESTION: 227 You plan to deploy a package to a server that has SQL Server installed. The server contains a SQL Server Integration Services Catalog. You need to ensure that the package credentials are encrypted. Which protection level should you set for the package? A. EncryptSensitivewithUserKey B. EncryptAllWithUserKey C. ServerStorage D. EncryptSensitivewithPassword Answer: D QUESTION: 228 DRAG DROP You are maintaining a SQL Server Integration Services (SSIS) package. The package uses custom functionality that is implemented in Microsoft Visual C#. The implementation of the custom functionality changes overtime. The design of the package allows you to deploy new releases of the custom functionality without redeploying the entire package. You need to implement and deploy an update to the custom functionality without requiring package redeployment. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
QUESTION: 229 You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day. Referential integrity must be enforced declaratively. You need to design a solution that can join a single time dimension to both fact tables. What should you do?