PrepAway - Latest Free Exam Questions & Answers

You need to create the SSIS catalog on the production server

You install a SQL Server 2012 database engine instance on a production server. A month
later, you install SQL Server 2012 Integration Services (SSIS).
You must develop an SSIS project and deploy it to the server by using the Project
Deployment model.
Operations Log records that are outside the configured retention period must be cleaned
automatically.
You need to create the SSIS catalog on the production server.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)

PrepAway - Latest Free Exam Questions & Answers

A.
Enable XP Command Shell.

B.
Enable CLR Integration.

C.
Enable OLE Automation.

D.
Start the SQL Server Browser service.

E.
Enable Cross Database Ownership Chaining

F.
Start the SQL Server Agent service

G.
Enable Ad Hoc Remote Queries.

4 Comments on “You need to create the SSIS catalog on the production server


Leave a Reply