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.)

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.)

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.

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

jml

jml

I think SQL Server agent is needed to clean operation Log automatically.
https://msdn.microsoft.com/en-us/library/hh479588.aspx

To maintain the size of the operations data, the SSIS Server Maintenance Job in SQL Server Management Studio is used to remove old data. This SQL Server Agent job is created when Integration Services is installed.

Reply