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

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.Create an OnError event handler.
• B.Create a reusable custom logging component.
• C.Run the package by using the dtexec /rep /conn command.
• D.Use the Project Deployment Wizard.
• E.Use the dtutil /copy command.
• F.Run the package by using the dtexec /dumperror /conn command.
• G.Use the gacutil command.
• H.Deploy the package by using an msi file.
• I.Add a data tap on the output of a component in the package data flow.
• J.Deploy the package to the Integration Services catalog by using dtutfl and use SQL Server to store the configuration.
• K.Run the package by using the dtexecui.exe utility and the SQL Log provider.

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 Standard (64-bit) x64 on the database server
• D.SQL Server 2012 Data Center (64-bit) x64 on the database server

HOTSPOT
You are designing a package control flow. The package moves sales order data from a Windows Azure SQL Database transactional database to an on-premise reporting database. The package will run several times a day, while new sales orders are being added to the transactional database.
The current design of the package control flow is shown in the answer area. (Click the Exhibit button.)

---
The Insert New Orders Data Flow task must meet the following requirements:
Usage of the tempdb database should not be impacted.
Concurrency should be maximized, while only reading committed transactions.
If the task fails, only that task needs to be rolled back.
You need to configure the Insert New Orders Data Flow task to meet the requirements.
How should you configure the transaction properties? To answer, select the appropriate setting or settings in the answer area.

Correct Answer:

A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database.
To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP web service instead of from a weekly flat file.
You need to implement the change to the existing package while minimizing the development effort.
What should you use to call the web service to retrieve the daily exchange rates?

• A.a Script component
• B.a Script task
• C.a Web Service source
• D.a Web Service task