70-463 · Question #90
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…
The correct answer is B. Enable CLR Integration. F. Start the SQL Server Agent service. Creating the SSIS catalog (SSISDB) has two hard requirements: (1) CLR Integration must be enabled because the catalog database uses CLR stored procedures and functions internally-without it, the catalog cannot be created. (2) The SQL Server Agent service must be running because…
Question
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.)
Options
- AEnable XP Command Shell.
- BEnable CLR Integration.
- CEnable OLE Automation.
- DStart the SQL Server Browser service.
- EEnable Cross Database Ownership Chaining.
- FStart the SQL Server Agent service.
- GEnable Ad Hoc Remote Queries.
How the community answered
(44 responses)- A14% (6)
- B73% (32)
- C7% (3)
- D5% (2)
- E2% (1)
Explanation
Creating the SSIS catalog (SSISDB) has two hard requirements: (1) CLR Integration must be enabled because the catalog database uses CLR stored procedures and functions internally-without it, the catalog cannot be created. (2) The SQL Server Agent service must be running because the catalog relies on a SQL Agent job ('SSIS Server Maintenance Job') to automatically purge operation log records that exceed the configured retention period, which the question explicitly requires. The other options are not prerequisites: XP Command Shell, OLE Automation, Cross Database Ownership Chaining, and Ad Hoc Remote Queries are unrelated to catalog creation. SQL Server Browser enables named-instance discovery over the network but is not required to create the catalog.
Topics
Community Discussion
No community discussion yet for this question.