Your team is creating SQL Server Integration Services (SSIS) packages that have several dependencies. The packages use parameters for configuration purposes.Your company's IT policies include the following change control requirements:✑ After a package is ready for deployment, your team must hand over the process to junior IT personnel.✑ The process must guarantee that when a package has been validated, that same package (and all its dependencies) is deployed to production.✑ The process must be repeatable and reliable and must be executed with the least administrative and training effort by junior IT personnel.You need to use the most appropriate deployment unit to satisfy the company policies, while minimizing issues such as incorrect version or configuration.Which type of deployment unit should you use?
DRAG DROP -You are editing a SQL Server Integration Services (SSIS) package that uses checkpoints.The package performs the following steps:✑ Download a sales transaction file by using FTP.✑ Truncate a staging table.✑ Load the contents of the file to the staging table.✑ Merge the data with another data source for loading to a data warehouse.The checkpoints are currently working such that if any of the four steps fail, the package will restart from the failed step the next time it executes.You need to modify the package to ensure that if either the Truncate Staging Table or the Load Sales to Staging task fails, the package will always restart from theTruncate Staging Table task the next time the package runs.Which three steps 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.)Select and Place:
You are developing a SQL Server Integration Services (SSIS) package.The package sources data from an HTML web page that lists product stock levels.You need to implement a data flow task that reads the product stock levels from the HTML web page.Which data flow sources should you use? (Select Two.)
DRAG DROP -You are building a fact table in a data warehouse.The table must have a columnstore index. The table cannot be partitioned.You need to design the fact table and load it with data.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.)Select and Place:
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server.The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project.You need to meet the requirements by using the least amount of administrative effort.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?
