PrepAway - Latest Free Exam Questions & Answers

You need to configure the SQL Server environment to support these packages

You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed.
You plan to deploy new SSIS packages to the server.The SSIS packages use the Project Deployment Model
together with parameters and Integration Services environment variables. You need to configure the SQL
Server environment to support these packages. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Create SSIS configuration files for the packages.

B.
Create an Integration Services catalog.

C.
Install Data Quality Services.

D.
Install Master Data services.

Explanation:
According to these references, this answer looks correct.
Reference:
http://msdn.microsoft.com/en-us/library/hh479588.aspx
http://msdn.microsoft.com/en-us/library/hh213290.aspx
http://msdn.microsoft.com/en-us/library/hh213373.aspx


Leave a Reply