[Free] Download New Updated (February 2016) Microsoft 70-458 Practice Tests 41-50

Ensurepass

QUESTION 41

DRAG DROP

You are designing a package control flow. The package moves sales order data from a SQL Azure

transactional database to an on-premise reporting database. The package will run several times a

day, while new sales orders are being added to the transactional database. The current design of the package control flow is shown in the answer area.

 

clip_image002

 

The Insert New Orders Data Flow task must meet the following requirements:

 

Ÿ   Usage of the tempdb database should not be impacted.

Ÿ   Concurrency should be maximized, while only reading committed transactions.

Ÿ   If the task fails, only that task needs to be rolled back.

 

You need to configure the Insert New Orders Data Flow task to meet the requirements. How

should you configure the transaction properties? To answer, select the appropriate setting or

settings in the answer area.

 

Select and Place:

clip_image003

 

Correct Answer: “IsolationLeve as Choas”

 

 

QUESTION 42

You are designing a SQL Server Integration Services (SS1S) package that uploads a file to a table

named Orders in a SQL Azure database. The company’s auditing policies have the following

requirements:

 

Ÿ   An entry must be written to a dedicated SQL Server log table named OrderLog.

Ÿ   The entry must be written as soon as the file upload task completes.

 

You need to meet the company’s policy requirements. Which event handler should you use?

 

A.       OnProgress

B.       Onlnformation

C.       OnPostExecute

D.      
OnComplete

 

Correct Answer: C

 

 

 

 

 

QUESTION 43

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data

warehouse hosted on SQL Azure. The package uses a Foreach container to process text files

found in a folder. The package must be deployed to a single server by using the Project

Deployment model. Multiple SQL Server Agent jobs call the package. Each job is executed on a

different schedule. Each job passes a different folder path to the package. You need to configure

the package to accept the folder path from each job. Which package configuration should you

use?

 

A.     .dtsConfig file

B.     Registry Entry

C.     Environment Variable

D.     Parent Package Variable

E.      XML Configuration File

 

Correct Answer: C

 

 

QUESTION 44

You are developing a SQL Server Integration Services (SSIS) package to load data into a data

warehouse.

 

clip_image005

 

You need to establish the correct order for loading each table to maximize parallel processing.

Which order should you use?

 

A.       1. DimCurrency, DimScenario, DimAccount in parallel

2. DimOrganization

3. FactFinance

B.       1. DimCurrency, DimOrganization in parallel

2. DimScenario, DimAccount in parallel

3. FactFinance

< font face="Calibri">C.       1. DimCurrency, FactFinance in parallel

2. DimOrganization, DimScenario, DimAccount in parallel

D.       1. FactFinance

2. DimOrganization, DimScenario, DimAccount in parallel

3. DimCurrency

E.       1. DimCurrency

2. DimOrganization

3. DimScenario, DimAccount in parallel

4. FactFinance

 

Correct Answer: A

 

 

QUESTION 45

You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a

data warehouse every night. The SQL Azure data contains many misspellings and variations of

abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose

the closest-matching string from a reference table of allowed values. The number of rows in the

reference table is very large. If no acceptable match is found, the Fuzzy Lookup transformation

passes a null value. The current setting for the Fuzzy Lookup similarity threshold is 0.50. Many

values are incorrectly matched. You need to ensure that more accurate matches are made by the

Fuzzy Lookup transformation without degrading performance. What should you do?

 

A.     Change the Exhaustive property to True,

B.     Change the similarity threshold to 0.55.

C.     Change the similarity threshold to 0.40.

D.     Increase the maximum number of matches per lookup.

 

Correct Answer: B

 

 

QUESTION 46

Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does

not complete and nothing is processed. You need to ensure that package logging occurs. Your

solution must minimize deployment and development efforts. What should you do?

 

A.       Create a reusable custom logging component.

B.       Use the gacutil command.

C.       Use the Project Deployment Wizard.

D.       Run the package by using the dtexec /rep /conn command.

E.       Add a data tap on the output of a component in the package data flow.

F.        Create an OnError event handler.

G.       Use the dtutil /copy command.

H.       Deploy the package by using an msi file.

I.         Run the package by using the dtexec /dumperror /conn command.

J.        Run the package by using the dtexecui.exe utility and the SQL Log provider.

K.       Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to

store the configuration.

 

Correct Answer: C

 

 

QUESTION 47

To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging

methodology is put in place. The methodology has the following requirements:

 

Ÿ   The deployment process must be simplified.

Ÿ   All the logs must be centralized in SQL Server.

Ÿ   Log data must be available via reports or T-SQL.

Ÿ   Log archival must be automated.

 

You need to configure a logging methodology that meets the requirements while minimizing the

amount of deployment and development effort. What should you do?

 

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

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

running the dtexecui.exe utility.

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

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

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

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

configuration in SQL Server.

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

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

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

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

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

 

Correct Answer: B< /span>

 

 

 

 

 

 

 

 

QUESTION 48

You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. A

package in the project uses a custom task component. You need to ensure that the custom object

is deployed on the test environment correctly. What should you do?

 

A.     Run the package by using the dtexec /rep /conn command.

B.     Create a reusable custom logging component.

C.     Create an OnError event handler.

D.     Use the gacutil command.

E.      Use the dtutil /copy command.

F.      Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to

store the configuration.

G.     Run the package by using the dtexec /dumperror /conn command.

H.     Use the Project Deployment Wizard.

I.       Deploy the package by using an msi file.

J.       Add a data tap on the output of a component in the package data flow.

K.      Run the package by using the dtexecui.exe utility and the SQL Log provider.

 

Correct Answer: D

 

 

QUESTION 49

You are deploying a project to the SQL Server Integration Services (SSIS) catalog. You need to

ensure that the project is deployed to the production environment with the least amount of

administrative effort. What should you do?

 

A.       Create an On Error event handler.

B.       Add a data tap on the output of a component in the package data flow.

C.       Use the gacutil command.

D.       Create a reusable custom logging component.

E.       Run the package by using the dtexecui.exe utility and the SQL Log provider.

F.        Run the package by using the dtexec /rep /conn command.

G.       Use the Project Deployment Wizard.

H.       Run the package by using the dtexec /dumperror /conn command.

I.         Use the dtutil /copy command.

J.        Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to

store the configuration.

K.       Deploy the package by using an msi file.

 

Correct Answer: G

 

 

 

 

QUESTION 50

You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy

system. Data integrity in the legacy system is very poor. Invalid rows are discarded by the package

but must be logged to a CSV file for auditing purposes. You need to establish the best technique

to log these invalid rows while minimizing the amount of development effort. What should you

do?

 

A.       Add a data tap on the output of a component in the package data flow.

B.       Deploy the package by using an msi file.

C.       Run the package by using the dtexecui.exe utility and the SQL Log provider.

D.       Uses the dtutil /copy command.

E.       Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to

store the configuration.

F.        Create an OnError event handler.

G.       Uses the Project Deployment Wizard.

H.       Use the gacutil command.

I.         Create a reusable custom logging component.

J.        Run the package by using the dtexec /rep /conn command.

K.       Run the package by using the dtexec /dumperror /conn command.

 

Correct Answer: A

 

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

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