[Free] Download New Updated (February 2016) Microsoft 70-458 Practice Tests 61-70
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:
Correct Answer:
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:
Correct Answer:
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…
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF