You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy.The package reads data from a source system. Depending on the value in a source column, the package redirects rows to one of five different data flow paths.You need to add a data flow transformation to support the package redirection.Which data flow transformation should you use?
You are designing a data warehouse for a fresh food distribution business that stores sales by individual product. It stores sales targets by product category.Products are classified into subcategories and categories.Each product is included in only a single product subcategory, and each subcategory is included in only a single category.The data warehouse will be a data source for an Analysis Services cube.The data warehouse contains two fact tables:✑ factSales, used to record daily sales by product✑ factProductTarget, used to record the monthly sales targets by product categoryReports must be developed against the warehouse that reports product sales by product, category and subcategory, and product sales targets.You need to design the product dimension. The solution should use as few tables as possible while supporting all the requirements.What should you do?
You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages.All packages in the project must connect to the same database. The server name for the database must be set by using a parameter named ServerParam when any package in the project is executed.You need to develop this project with the least amount of development effort.What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.The project will be deployed to an SSIS catalog folder where Environments have already been created. You need to deploy the project. What should you do?
You are reviewing the design of a student dimension table in an existing data warehouse hosted on SQL Azure.The current dimension design does not allow the retention of historical changes to student attributes such as ParentOccupation.You need to redesign the dimension to enable the full historical reporting of changes to multiple student attributes including ParentOccupation.What should you do?
You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-stepSQL Server Agent job.You make changes to the package that should improve performance.You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal.What should you do?
