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-step SQL 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?

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?

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 source should you use?

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 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 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 completing the installation of the Data Quality Server component of SQL Server Data Quality
Services (DQS). You need to complete the post-installation configuration.
What should you do?

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 developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse.
The package consists of several data flow tasks.
The package experiences intermittent errors in the data flow tasks.
If any data flow task fails, all package error information must be captured and written to a SQL Server
table by using an OLE DB connection manager.You need to ensure that the package error information is captured and written to the table.
What should you do?

You are developing a SQL Server Integration Services (SSIS) project to read and write data from a
Windows Azure SQL Database database to a server that runs SQL Server 2012.
The connection will be used by data flow tasks in multiple SSIS packages. The address of the target
Windows Azure SQL Database database will be provided by a project parameter.
You need to create a solution to meet the requirements by using the least amount of administrative
effort and maximizing data flow performance.
What should you do?