You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a
local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server
Agent job. The SSIS package accesses a network share when exporting data from a SQL Server database.
When you execute the SQL Server Agent job, it failsdue to a permissions failure on a share on a remote
server. You need to ensure that the SQL Server Agent job can execute the SSIS package. Which four 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 creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source
table. The fact table and source table are located in a SQL Azure database. The source table has a price field
and a tax field. The OLE DB source uses the data access mode of Table. You have the following
requirements:
• The fact table must populate a column named TotalCost that computes the sum of the price and tax columns.
• Before the sum is calculated, any records that have a price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools.
In what sequence should you order four of the listed components for the data flow task? (To answer, move the
appropriate components from the list of components to the answer area and arrange them in the correct order.)

You are designing a SQL Server Integration Services(SSIS) package to execute 12 Transact-SQL (T-SQL)
statements on a SQL Azure database. The T-SQL statements may be executed in any order. The T-SQL
statements have unpredictable execution times. You have the following requirements:
• The package must maximize parallel processing of the T-SQL statements.
• After all the T-SQL statements have completed, a Send Mail task must notify administrators.
You need to design the SSIS package. 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 editing a SQL Server Integration Services (SSIS) package that uses checkpoints.
The package performs the following steps:
1. Download a sales transaction file by using FTP.
2. Truncate a staging table.
3. Load the contents of the file to the staging table.
4. 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 the Truncate 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.)

A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog. To troubleshoot some
data issues, you must output the data streaming through several data flows into text files for furtheranalysis.
You have the list of data flow package paths and identification strings of the various task componentsthat must
be analyzed. You need to create these output files with the least amount of administrative and development
effort. Which three stored procedures should you execute in sequence? (To answer, move the appropriate
actions from the list of actions to the answer areaand arrange them in the correct order.)

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.)

You are developing a SQL Server Integration Services (SSIS) package that is ready for deployment to a
production server. The package contains sensitive information secured by using the
EncryptSensitiveWithUserKey package protection level. You are preparing the package for deployment by the
production operations team. You need to ensure thatthe production operations team can open and execute the
package without re-entering the sensitive information. 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.)

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.)