Administering a SQL Database Infrastructure — Question 79

You administer a Microsoft SQL Server 2016 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?

Answer options

• A. Create SSIS configuration files for the packages.
• B. Create an Integration Services catalog.
• C. Install Data Quality Services.
• D. Install Master Data services.

Correct answer: B

Explanation

The correct answer is B, as creating an Integration Services catalog is necessary to deploy and manage SSIS packages using the Project Deployment Model. The other options, such as creating SSIS configuration files or installing additional services like Data Quality Services or Master Data Services, do not directly support the deployment of SSIS packages in this context.