Online Access Free 070-458 Exam Questions

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.Install ADOMD.NET.
• B.Run the DQSInstaller.exe command.
• C.Make the data available for DQS operations.
• D.Run the Configuration component in the Data Quality Client.

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:

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. An Execute SQL task in the package checks product stock levels and sets a package variable named InStock to TRUE or FALSE depending on the stock level found.
After the successful execution of the Execute SQL task, one of two data flow tasks must run, depending on the value of the InStock variable.
You need to set the precedence constraints.
Which value for the evaluation operation should you use? (To answer, select the appropriate option for the evaluation operation in the answer area.)

Correct Answer:

You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an application.
You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.
What should you do?

• A.Query the sys.dm_db_missing_index_details DMV.
• B.Query the sys.dm_db_index_usage_stats DMV.
• C.Query the sys.dm_db_missing_index_columns DMV.
• D.Use the Database Engine Tuning Advisor.

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