Microsoft
70-457 · Question #179
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. See the full explanation below for the reasoning.
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
(33 responses)- A6% (2)
- B76% (25)
- C12% (4)
- E3% (1)
- G3% (1)
Community Discussion
No community discussion yet for this question.