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

Ensurepass

QUESTION 61

DRAG DROP

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.

 

Select and Place:

clip_image002

 

Correct Answer:

clip_image004

 

 

 

 

 

 

 

 

 

 

 

QUESTION 62

You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL

tasks and no other tasks. The package and all three Execute SQL tasks have their

TransactionOption property set to Supported. You need to ensure that if any of the Execute SQL

tasks fail, all three tasks will roll back their changes. What should you do?

 

A.     Change the TransactionOption property of the package to Required.

B.     Change the TransactionOption property of all three Execute SQL tasks to Required.

C.     Move the three Execute SQL tasks into a Sequence container.

D.     Move the three Execute SQL tasks into a Foreach Loop container.

 

Correct Answer: A

 

 

QUESTION 63

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

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

requirements:

< span lang="EN-US"> 

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

B.     OnVariableValueChanged

C.     OnExecStatusChanged

D.     OnPostExecute

 

Correct Answer: D

 

 

QUESTION 64

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

relational database to a data warehouse. You are importing data from a relational table named

Projects. The table has change data capture enabled on all columns. You need to process only the

most recent values from rows that have been inserted or updated since the previous execution of

the package. Which query should you use as the data source?

 

A.     SELECT * FROM cdc.fn_cdc_get_all_changes_Projects

(@from_lsn, @to_lsn, N’ all update old’)

B.     SELECT * FROM cdc.fn_cdc_get_all_changes_Projects (@from_lsn, @to_lsn, N’ all’)

C.     SELECT * FROM cdc.fn_cdc_get_net_changes_Projects (@from_lsn, @to_lsn)

D.     SELECT * FROM cdc.Projects_CT WHERE

@from_lsn >= _$start_lsn AND @to_lsn < _$start_lsn

 

Correct Answer: C

 

 

QUESTION 65

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

table on ServerA. The package includes a data flow and is executed on ServerB. The destination

table has its own identity column. The destination data load has the following requirements:

 

Ÿ   The identity values from the source table must be used.

Ÿ   Default constraints on the destination table must be ignored.

Ÿ   Batch size must be 100,000 rows.

 

You need to add a destination and configure it to meet the requirements. Which destination

should you use?

 

A.     ADO NET Destination with Bulk Insert

B.     SQL Server Destination

C.     OLE DB Destination with Fast Load

D.     ADO NET Destination without Bulk Insert

E.      OLE DB Destination without Fast Load

 

Correct Answer: C

 

 

QUESTION 66

You are adding a new capability to s
everal dozen SQL Server Integration Services (SSIS) packages.

The new capability is not available as an SSIS task. Each package must be extended with the same

new capability. You need to add the new capability to all the packages without copying the code

between packages. What should you do?

 

A.     Use the Expression task.

B.     Use the Script component.

C.     Use the Script task.

D.     Develop a custom task.

E.      Develop a custom component.

 

Correct Answer: D

 

 

 

 

 

QUESTION 67

You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions

from a source system
into a data warehouse hosted on SQL Azure. One of the columns in the data

source is named ProductCode. Some of the data to be loaded will reference products that need

special processing logic in the data flow. You need to enable separate processing streams for a

subset of rows based on the source product code. Which data flow transformation should you

use?

 

A.     Source Assistant

B.     Audit

C.     Destination Assistant

D.     Script Component

 

Correct Answer: D

 

 

QUESTION 68

You are completing the installation of the Data Quality Server component of SQL Server Data

Quality Services (DQS). You need to complete the post-installation configuration. What should

you do?

 

A.       Run the dbimpexp.exe command.

< p class="MsoListParagraph" style="cursor: auto; text-justify: inter-ideograph; margin: 0cm 0cm 0pt 21pt; line-height: normal; text-indent: -21pt; mso-char-indent-count: 0; mso-list: l3 level1 lfo8" align="justify">B.       Install the data providers that are used for data refresh.

C.       Run the DQSInstalIer.exe command.

D.       Install the Analysis Services OLE DB Provider.

 

Correct Answer: C

 

 

QUESTION 69

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client

application to modify an existing knowledge base. In the mapping configuration, two of the three

columns are mapped to existing domains in the knowledge base. The third column, named Team

Type, does not yet have a domain. You need to complete the mapping of the Team Type column.

What should you do?

 

A.     Add a column mapping for the Team Type column.

B.     Add a domain for the Team Type column.

C.     Map a composite domain to the source
column.

D.     Create a composite domain that includes the Team Type column.

 

Correct Answer: B

 

 

QUESTION 70

HOTSPOT

You are developing a data flow to load sales data into a fact table. In the data flow, you configure

a Lookup Transformation in full cache mode to look up the product data for the sale. The lookup

source for the product data is contained in two tables. You need to set the data source for the

lookup to be a query that combines the two tables. Which page of the Lookup Transformation

Editor should you select to configure the query?

 

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

 

Hot Area:

clip_image006

 

Correct Answer:

clip_image008

 

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…