QUESTION 101

DRAG DROP

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.

 

clip_image002

 

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.

 

Build List and Reorder:

clip_image004

 

Correct Answer:

clip_image006

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 102

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 further analysis. You have the list of data flow package paths and identification strings of the various task components that 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 area and arrange them in the correct order.

 

Build List and Reorder:

clip_image008

 

Correct Answer:

clip_image010

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 103

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.

 

Build List and Reorder:

clip_image012

 

Correct Answer:

clip_image014

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 104

DRAG DROP

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 that the 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.

 

Build List and Reorder:

clip_image016

 

Correct Answer:

clip_image018

 

 

 

 

QUESTION 105

You develop 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 Development1. The project will be deployed to several servers that run SQL Server 2012. The project accepts one required parameter. The data type of 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 the answer area and arrange them in the correct order.

 

Build List and Reorder:

clip_image020

 

Correct Answer:

clip_image022

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 106

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 the answer area and arrange them in the correct order.

 

Build List and Reorder:

clip_image024

 

Correct Answer:

clip_image026

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 107

A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project includes a project Connection Manager to connect to the 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 by using 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.

 

To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

clip_image027

 

Correct Answer:

clip_image028

 

 

QUESTION 108

You are validating whether a SQL Server Integration Services (SSIS) package named Master.dtsx in the SSIS catalog is executing correctly. You need to display the 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 to the answer area and arrange them in the correct order.

 

Build List and Reorder:

clip_image030

 

Correct Answer:

clip_image032

 

 

QUESTION 109

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 determine whether 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.

 

Build List and Reorder:

clip_image034

 

Correct Answer:

clip_image036

 

 

QUESTION 110

DRAG DROP

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.

 

Build List and Reorder:

clip_image038

 

Correct Answer:

clip_image040

 

Free VCE & PDF File for Microsoft 70-463 Real Exam

Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…