[Free] Download New Updated (October 2016) Microsoft 70-463 Real Exam 91-100

Ensurepass

QUESTION 91

You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing.

Issues concerning addresses are discovered in the data warehouse that you manage. Validation must separate the addresses into three categories:

 

Ÿ   Valid addresses

Ÿ   Autocorrected addresses

Ÿ   Invalid addresses

 

You need to enhance the SSIS packages to perform address validation by using an external service. Which transformation should you use?

 

To answer, drag the appropriate transformation from the list of options to the correct location or locations in the answer area.

 

Select and Place:

clip_image002

 

Correct Answer:

clip_image004

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 92

You are designing a SQL Server Integration Services (SSIS) package configuration strategy. The package configuration must meet the following requirements:

 

Ÿ   Include multiple properties in a configuration.

Ÿ   Support several packages with different configuration settings.

 

You need to select the appropriate configuration. Which configuration type should you use?

 

To answer, select the appropriate option from the drop-down list in the dialog box.

 

Hot Area:

clip_image006

 

Correct Answer:

clip_image008

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 93

You are designing a SQL Server Integration Services (SSIS) package configuration strategy. The package configuration must meet the following requirements:

 

Ÿ   Include multiple properties in a configuration.

Ÿ   Force packages to load all settings in the configuration.

Ÿ   Support Encrypting File System (EFS) formats.

 

You need to select the appropriate configuration. Which configuration type should you use?

 

To answer, select the appropriate option from the drop-down list in the dialog box.

 

Hot Area:

clip_image009

 

Correct Answer:

clip_image011

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 94

DRAG DROP

You are developing a SQL Server Integration Services (SSIS) package. The package uses custom functionality that accesses a SQL Server database. The custom functionality must be implemented by using Language Integrated Query (LINQ). You need to ensure that the LINQ code can be debugged at design time. What should you select from the SSIS Toolbox?

 

To answer, drag the appropriate item to the correct location in the answer area.

 

Select and Place:

clip_image013

 

Correct Answer:

clip_image015

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 95

HOTSPOT

You are editing a SQL Server Integration Services (SSIS) package. You need to edit the Script task that has an expression defined. Which task should you select?

 

To answer, select the appropriate setting or settings in the answer area.

 

Hot Area:

clip_image017

 

Correct Answer:

clip_image019

 

 

QUESTION 96

HOTSPOT

You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools. A package Connection Manager has been parameterized with project scope. You need to display the parameters that have been generated for the Connection Manager. What should you use?

 

To answer, select the appropriate setting or settings in the answer area.

 

Hot Area:

clip_image021

 

Correct Answer:

clip_image023

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 97

You are building a SQL Server Integration Services (SSIS) package to load data from all files that are automatically copied to a directory each night through an external FTP process. You need to load data from all copied files to a destination table in SQL Server. 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_image025

 

Correct Answer:

clip_image027

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 98

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 fails due 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.

 

Build List and Reorder:

clip_image029

 

Correct Answer:

clip_image031

 

 

 

 

QUESTION 99

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.

 

Build List and Reorder:

clip_image033

 

Correct Answer:

clip_image035

 

 

 

 

 

 

 

 

 

 

QUESTION 100

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.

 

Build List and Reorder:

clip_image037

 

Correct Answer:

clip_image039

 

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…