You are designing an extract, transform, load (ETL)process with SQL Server Integration Services (SSIS). Two
packages, Package A and Package B, will be designed. Package A will execute Package B. Both packages
must reference a file path corresponding to an input folder where files will be located for further processing. You
need to design a solution so that the file path canbe easily configured with the least administrativeand
development effort. Which four actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer areaand arrange them in the correct order.)

A SQL Server Integration Services (SSIS) package named DataFeed interacts with an external vendor data
feed. The package is executed several times a day, either as part of other packages’ control flow or by itself.
The external data feed is unreliable because network failures and slow response times are frequent. The
package is currently deployed on the file system. To analyze the reliability of the external data feed, you must
collect execution data. Every time the DataFeed package is executed, the following information must be
logged:
• Start Time
• End Time
• Execution Result
• Execution Duration
You need to design a logging solution that meets the requirements by using the least amount of administrative
and development effort. Which three actions should you perform in sequence? (To answer, move the
appropriate actions from the list of actions to theanswer area and arrange them in the correct order.)

You develop a SQL Server Integration Services (SSIS) project by using the Project Deployment model. The
project contains many packages. It is deployed on aserver named Development1. The project will be deployed
to several servers that run SQL Server 2012. The project accepts one required parameter. The data typeof the
parameter is a string. A SQL Agent job is created that will call the master.dtsx package in the project. A job step
is created for the SSIS package. The job must pass the value of an SSIS Environment Variable to the project
parameter. The value of the Environment Variable must be configured differently on each server that runs SQL
Server. The value of the Environment Variable must provide the server name to the project parameter. You
need to configure SSIS on the Development1 server to pass the Environment Variable to the package. Which
four actions should you perform in sequence by using SQL Server Management Studio? (To answer, move the
appropriate actions from the list of actions to theanswer area and arrange them in the correct order.)

You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive
property. You need to create a project parameter and configure it so that its value is encrypted when it is
deployed to the SSIS catalog. Which three steps should you perform in sequence? (To answer, move the
appropriate actions from the list of actions to theanswer area and arrange them in the correct order.)

A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project
includes a project Connection Manager to connect tothe data warehouse. The SSIS catalog includes
two Environments:
• Development
• QA
Each Environment defines a single Environment Variable named ConnectionString of type string. The
value of each variable consists of the connection string to the development or QA data warehouses.
You need to be able to execute deployed packages byusing either of the defined Environments.
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.)

You are validating whether a SQL Server IntegrationServices (SSIS) package named Master.dtsx in the SSIS
catalog is executing correctly. You need to displaythe number of rows in each buffer passed between each
data flow component of the package. Which three actions should you perform in sequence? (To answer, move
the appropriate actions from the list of actions tothe answer area and arrange them in the correct order.)

A Data Flow task in a SQL Server Integration Services (SSIS) package produces run- time errors. You need to
edit the package to log specific error messages. 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.)

You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment model.
You need to monitor control flow tasks to determinewhether any of them are running longer than usual.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.)

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment model.
The project contains many packages. It is deployed on a server named SQLTest1. The project will be deployed
to several servers that run SQL Server 2012. The project accepts one required parameter. The data typeof the
parameter is a string. A SQL Agent job is created that will call the Loading.dtsx package in the project. A job
step is created for the SSIS package. The job must pass the value of an SSIS Environment Variable to the
project parameter. The value of the Environment Variable must be configured differently on each serverthat
runs SQL Server. The value of the Environment Variable must provide the server name to the project
parameter. You need to configure SSIS on the SQLTest1 server to pass the Environment Variable to the
package. Which four actions should you perform in sequence by using SQL Server Management Studio? (To
answer, move the appropriate actions from the list of actions to the answer area and arrange them in the
correct order.)

You are designing a SQL Server Integration Services(SSIS) package. The package moves order-related data
to a staging table named Order. Every night the staging data is truncated and then all the recent orders from
the online store database are inserted into the staging table. Your package must meet the following
requirements:
If the truncate operation fails, the package execution must stop and report an error.
If the Data Flow task that moves the data to the staging table fails, the entire refresh operation must be
rolled back.
For auditing purposes, a log entry must be entered in a SQL log table after each execution of the DataFlow
task.
The TransactionOption property for the package is set to Required. You need to design the package to meet
the requirements. How should you design the controlflow for the package? (To answer, drag the appropriate
setting from the list of settings to the correct location or locations in the answer area.)