Ensurepass

QUESTION 161

You are developing a SQL Server Integration Services (SSIS) project to read and write data from a

Windows Azure SQL 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 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?

 

A.     Use an SSIS Script task that uses the custom assembly to parse the text data when inserting

it.

B.      Use an SSIS Script transformation that uses the custom assembly to parse the text data when

inserting it.

C.      Create a SQL Common Language Runtime (SQLCLR) function that uses the custom assembly

to parse the text data, deploy it in the Windows Azure SQL Database, and use it when

inserting data.

D.     Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom

assembly to parse the text data, deploy it in the Windows Azure SQL Database, and use it

when inserting data.

 

Correct Answer: A

 

 

QUESTION 162

You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment

Model. A package in the project extracts data from a Windows Azure SQL Database. The package

is deployed to SQL Server. The package is not producing the desired results. You need to generate

the .mdmp and .tmp debug files in order to troubleshoot the issues. What should you do?

 

A.       Execute the catalog.add_data_tap stored procedure with the package execution_id.

B.       Execute the catalog.create_execution_dump stored procedure with the package

execution_id.

C.       Run the DTEXEC utility with the /DumpOnError option.

D.       Run the DTEXEC utility with the /Reporting V option.

 

Correct Answer: C

 

 

QUESTION 163

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

ParamConnection 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 answer presents a part

of the solution. Choose all that apply.)

 

A.     Create a package parameter named ConnectionName in each package.

B.      Edit each package Connection Manager. Set the ConnectionName property to

@[$Project::ParamConnection].

C.      Edit the project Connection Manager in Solution Explorer. Set the ConnectionName property

to @ [$Project::ParamConnection].

D.     Set the Sensitive property of the parameter to True.

E.      Create a project parameter named ConnectionName.

F.      Set the Required property of the parameter to True.

 

Correct Answer: CEF

 

 

QUESTION 164

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?

 

A.     Raw File source

B.      XML source

C.      Custom source component

D.     Flat File source

 

Correct Answer: C

 

 

 

 

 

 

 

QUESTION 165

You are deploying a new SQL Server Integration Services (SSIS) package to five servers.

The package must meet the following requirements:

 

Ÿ   .NET Common Language Runtime (CLR) integration in SQL Server must not be enabled.

Ÿ   The Connection Managers used in the package must be configurable without editing and

redeploying the package.

Ÿ   The deployment procedure must be automated as much as possible.

Ÿ   Performance must be maximized.

 

You need to set up a deployment strategy that meets the requirements. What should you do?

 

A.     Add an OnError event handler to the SSIS project.

B.      Use an msi file to deploy the package on the server.

C.      Open a command prompt and run the gacutil command.

D.     Open a command prompt and run the dtutil /copy command.

E.      Open a command prompt and run the dtexec /rep /conn command.

F.      Open a command prompt and run the dtexec /dumperror /conn command.

G.     Open a command prompt and execute the package by using the SQL Log provider and

running the dtexecui.exe utility.

H.     Create a reusable custom logging component and use it in the SSIS project.

I.       Configure the SSIS solution to use the Project Deployment Model.

J.       Configure the output of a component in the package data flow to use a data tap.

K.      Run the dtutil command to deploy the package to the SSIS catalog and store the

configuration in SQL Server.

 

Correct Answer: D

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 166

DRAG DROP

You are maintaining a SQL Server Integration Services (SSIS) package. The package uses custom

functionality that is implemented in Microsoft Visual C. The implementation of the custom

functionality changes overtime. The design of the package allows you to deploy new releases of

the custom functionality without redeploying the entire package. You need to implement and

deploy an update to the custom functionality without requiring package redeployment. 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.

 

Select and Place:

clip_image002

 

Correct Answer:

clip_image004

 

 

 

 

 

QUESTION 167

HOTSPOT

You are the data steward at your company. Duplicate customers exist in a Microsoft Excel

workbook. You create a Data Quality Services (DQS) knowledge base and matching policy to

identify these duplicate customers. You need to identify the duplicate customers. Which option

should you use?

 

To answer, select the appropriate option in the answer area.

 

Hot Area:

clip_image006

 

Correct Answer:

clip_image008

 

 

 

 

QUESTION 168

HOTSPOT

You are developing a SQL Server Integration Services (SSIS) package. The data source for the data

flow task is a table that has been configured as a change data capture (CDC) table. You are using a

CDC Source component to obtain the CDC data. The CDC Source component has the following

requirements:

 

Ÿ   The output must include metadata columns that indicate which source columns have

changed.

Ÿ   The output must return only one change row per source row that is modified in the current

CDC processing range.

 

You need to configure the CDC Source component. Which CDC processing mode should you

select?

 

To answer, configure the appropriate option or options in the dialog box in the answer area.

 

Hot Area:

clip_image010

 

Correct Answer:

clip_image012

 

 

QUESTION 169

HOTSPOT

You are developing a SQL Server Integration Services (SSIS) package. The package must run a

parameterized query against a Windows Azure SQL Database. You need to use the least amount

of development effort to meet the package requirement. Which task should you use?

 

To answer, select the appropriate task in the answer area.

 

Hot Area:

clip_image014

 

Correct Answer:

clip_image016

 

 

QUESTION 170

DRAG DROP

You are developing a SQL Server Integration Services (SSIS) package. The package contains an

ADO object source variable that holds a result set that was returned by a stored procedure

execution. You need to add and configure a container that will execute several tasks for each row

in the ADO object source variable. 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.

 

Select and Place:

clip_image018

 

Correct Answer:

clip_image020

 

 

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…