70-458 試験問題を無料オンラインアクセス

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
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.Run the package by using the dtexecui.exe utility and the SQL Log provider.
• C.Run the package by using the dtexec /rep /conn command.
• D.Create a reusable custom logging component.
• E.Use the dtutil /copy command.
• F.Run the package by using the dtexec /dumperror /conn command.
• G.Use the gacutil command.
• H.Create an OnError event handler.
• I.Deploy the package by using an msi file.
• J.Deploy the package to the Integration Services catalog by using dtutfl and use SQL Server to store the configuration.
• K.Use the Project Deployment Wizard.

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads rows from a source system and compares them to rows in a destination system. New rows will be inserted and changed rows will be updated.
You have used a Lookup transformation and a Conditional Split transformation. The Lookup transformation joins the source and destination table on the business key, and includes all columns from the destination table in the data flow output. The Conditional Split transformation inspects the destination columns and directs data flow to either insert new records or update existing records.
You need to configure the Lookup transformation to ensure that all records flow to the Conditional Split transformation, regardless of whether the rows match an existing row in the destination table.
Which setting should you select? (To answer, select the appropriate option in the answer area.)

正解：

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package contains an ActiveX Data Objects (ADO) 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.)

正解：

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server.
The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project.
You need to meet the requirements by using the least amount of administrative effort.
What should you do?

• A.For each target server, create separate Environments in the SSIS catalog of the host SQL Server SSIS instance. Select the appropriate Environment at package execution time.
• B.For each target server, create a separate package and include each package in the SSIS catalog. Run the appropriate server at package execution time.
• C.Create one registry configuration. Add a connection string for each target server. Choose the appropriate server in the package at build time.
• D.Create one XML configuration file. Add a connection string for each target server. Choose the appropriate server in the package at build time.

You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the source system.
You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations.
Which data flow transformation should you use?

• A.DQS Cleansing
• B.Merge Join
• C.CDC Splitter
• D.Pivot