QUESTION 3
You develop a SQL Server Integration Services (SSIS) package in a project by using the Project
Deployment Model. It is regularly executed within a multi-step SQL Server Agent job.
You make changes to the package that should improve performance.
You need to establish if there is a trend in the durations of the next 10 successful executions of the
package. You need to use the least amount of 070-461 dumps
administrative effort to achieve this goal.
What should you do?
A. After 10 executions, view the job history for the SQL Server Agent job.
B. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of
the All Executions report for the project.
C. Enable logging to the Application Event Log in the package control flow for the Onlnformation event.
After 10 executions, view the Application Event Log.
D. Enable logging to an XML file in the package control flow for the OnPostExecute event. After 10executions, view the XML file.
Correct Answer: B

QUESTION 4
A SQL Server Integration Services (SSIS) 2012 package 070-347 dumps
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 website
instead of from a weekly flat file. The public website hosts a comma-
separated values (CSV) file that contains one row per currency.
You need to download the CSV file to the environment.
What should you use to retrieve the document from the website?
A. a Script component
B. a Web Service 70-331 dumps
task
C. a Web Service source
D. a Script task
Correct Answer: D

QUESTION 5
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 Standard Edition SP1
B. Microsoft SharePoint Server 2010 Enterprise 070-489 dumps
Edition SP1
C. SQL Server 2012 Data Center (64-bit) x64 on the database server
D. SQL Server 2012 Enterprise (64-bit) x64 on the database server
Correct Answer: D

QUESTION 6
You are designing an Extract, Transform and Load (ETL) solution that loads data into dimension tables.
The ETL process involves many transformation steps.
You need to ensure that the design can provide:
Auditing information for compliance and business user acceptance Tracking and unique identification of
records for troubleshooting and error correction
What should you do?
A. Develop a Master 70-414 dumps
Data Services (MDS) solution.
B. Develop a Data Quality Services (DQS) solution.
C. Create a version control repository for the ETL solution.
D. Develop a custom data lineage solution.
Correct Answer: D

QUESTION 7
You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment
Model.
The project will contain 10 packages. All the packages must connect to the same data source anddestination.
You need to define and reuse the connection 70-486 dumps
managers in all the packages by using the least development
effort.
What should you do?
A. Implement parent package variables.
B. Copy and paste connection managers from one package to the others.
C. Implement project connection managers.
D. Implement package connection managers.
Correct Answer: C

QUESTION 8
You have a secured database that contains all of the customer data for your company. You plan to use a
project deployment model.
You need to create a SQL Server 1ntegration Services (SS1S) package that connects to the database by
using a dedicated username and password. 70-487 dumps
The solution must ensure that the password used for the
connection string is encrypted.
Which two actions should you perform? (Select Two)
A. Select the Sensitive check box for the catalog environment.
B. Set the sensitive property of the package parameter to True.
C. Modify the set_execution parameter_value stored procedure.
D. Set the package protection level to EncrypSensitiveWithPassword.
Correct Answer: CD

QUESTION 9
You are developing a SQL Server 1ntegration Services (SS1S) package.
The package sources data from an HTML web page that lists product stock levels.
You need to implement a data flow task that reads the product stock levels from the HTML web page.
Which data flow sources should 70-480 dumps
you use? Select Two
A. Raw File source
B. XML source
C. Custom source component
D. Flat File source
E. script component
Correct Answer: CE

QUESTION 10
You develop a SQL Server Integration Services (SSIS) package in a project by using the Project
Deployment Model. It is regularly executed within a multi-step SQL Server Agent job.
You make changes to the package that should improve performance.
You need to establish if there is a trend in the durations of the next 10 successful executions of the
package. You need to use the least 70-412 dumps
amount of administrative effort to achieve this goal.
What should you do?
A. Enable logging to an XML file in the package control flow for the Onlnformation event. After 10
executions, view the XML file.
B. After 10 executions, view the job history for the SQL Server Agent job.
C. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of
the All Executions report for the package.D. Enable logging to an XML file in the package control flow for the OnPostExecute event. After 10
executions, view the XML file.
Correct Answer: C

QUESTION 11
You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive
property.
You need to create a project parameter 70-417 dumps
and configure it so that its value is encrypted when it is deployed to
the SSIS catalog.
Which three steps 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.)
Select and Place:
Correct Answer: QUESTION 12
You are building a SQL Server Integration Services (SSIS) package to load data from all files that are
automatically copied to a directory each night through an external FTP process.
You need to load data from all copied files to a destination table in SQL Server.
Which three steps should you perform in sequence? (To answer, move the appropriate actions from the list
of actions to the answer area and arrange 70-532 dumps
them in the correct order.)
Select and Place:Correct Answer:

QUESTION 13
You are creating a sales data warehouse. When a product exists in the product dimension, you update the
product name. When a product does not exist, you insert a new record.
In the current implementation, the DimProduct table must be scanned twice, once for the insert and again
for the update. As a result, inserts and updates to the DimProduct table take longer than expected.
You need to create a solution that uses a single 070-413 dumps
command to perform an update and an insert.
How should you use a MERGE T-SQL statement to accomplish this goal? (To answer, drag the
appropriate answer choice from the list of options to the correct location or locations in the answer area.
You may need to drag the split bar between panes or scroll to view content.)Select and Place:Correct Answer:

QUESTION 14
You are designing a package control flow. The package moves sales order data from a SQL Azure
transactional database to an on-premise reporting 70-463 dumps
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