Online Access Free 070-458 Practice Test

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

Correct Answer:

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.Pivot
• B.CDC Splitter
• C.Merge Join
• D.DQS Cleansing

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 a separate XML configuration file. Select the XML configuration file at package execution time.
• B.Create one SSIS catalog Environment. Change the values of each Environment variable at package execution time.
• C.For each target server, create separate registry entry configurations. Select the registry entry at package execution time.
• D.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.

HOTSPOT
You are developing a SQL Server Integration Service (SSIS) package. The package loads a customer dimension table by using a data flow task.
Changes to the customer attributes must be tracked over time.
You need to produce a checksum value to identify the rows that have changed since the last Extract, Transform and Load (ETL) process execution. You need to use the least amount of development effort to achieve this goal.
Which transformation should you use? (To answer, select the appropriate transformation in the answer area.)

Correct Answer:

You are preparing to install SQL Server 2012 Master Data Services (MDS),
You need to ensure that the database requirements are met.
What should you install?

• A.Microsoft SharePoint Server 2010 Enterprise Edition SP1
• B.SQL Server 2012 Enterprise (64-bit) x64 on the database server
• C.SQL Server 2012 Data Center (64-bit) x64 on the database server
• D.SQL Server 2012 Standard (64-bit) x64 on the database server