Exam 70-764 topic 1 question 71 discussion

Actual exam question from Microsoft's 70-764

Question #: 71
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: B 🗳️
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.
References: https://docs.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages

by TheSwedishGuy at Jan. 24, 2020, 2:20 p.m.

Comments

Submit Cancel

TheSwedishGuy

Highly Voted 5 years, 3 months ago

SQL Server Integration Services (SSIS) is already installed. Just configure a catalog and you're set to recieve the packages.

upvoted 5 times

...

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam

Exam 70-764 topic 1 question 71 discussion

Comments

TheSwedishGuy

SY0-701