PrepAway - Latest Free Exam Questions & Answers

You administer a Microsoft SQL Server 2016 server that has SQL Server Integration Services (SSIS) installed.

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?

A. Create SSIS configuration files for the packages.

B. Create an Integration

Services catalog.

C. Install Data Quality Services.

D. Install Master Data services.

Use can use Project Deployment Model for a project, containing packages and parameters, which is deployed to the SSISDB catalog on an instance of SQL Server.

R

eferences: https://docs.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages


Leave a Reply