Free Microsoft 70-458 Exam Dumps Questions & Answers

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.SQL Server 2012 Enterprise (64-bit) x64 on the database server
• B.SQL Server 2012 Data Center (64-bit) x64 on the database server
• C.SQL Server 2012 Standard (64-bit) x64 on the database server
• D.Microsoft SharePoint Server 2010 Enterprise Edition SP1

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL Database database.
A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored procedure has only the rustomerlD parameter of type INT.
A project parameter named CustID will be mapped to the stored procedure parameter @CustomerID.
You need to ensure that the value of the CustID parameter is passed to the @CustomerID stored procedure parameter.
In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter? (To answer, drag the appropriate option or options to the correct location or locations in the answer area.)

Correct Answer:

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.
To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology.
The methodology has the following requirements:
Centralized logging in SQL Server
Simple deployment
Availability of log information through reports orT-SQL
Automatic purge of older log entries
Configurable log details
-----
You need to configure a logging methodology that meets the requirements while minimizing
the amount of deployment and development effort.
What should you do?

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

You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages.
All packages in the project must connect to the same database. The server name for the database must be set by using a parameter named ServerParam when any package in the project is executed.
You need to develop this project with the least amount of development effort.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Set the Sensitive property of the parameter to True.
• B.Create a package parameter named ServerName in each package.
• C.Edit each package Connection Manager. Set the ServerName property to @[$Project::ServerParam].
• D.Edit the project Connection Manager in Solution Explorer. Set the ServerName property to @[$Project::ServerParam].
• E.Create a project parameter named ServerName.
• F.Set the Required property of the parameter to True.

You are developing a SQL Server Integration Services (SSIS) package.
The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse.
You need to create a separate data flow path for data that has been modified since it was last processed.
Which data flow components should you use to identify modified data? (Each correct answer presents a complete solution. Choose all that apply.)

• A.Data Conversion
• B.Lookup
• C.Aggregate
• D.Slowly Changing Dimension
• E.Multicast