Microsoft
70-458 · Question #102
You are deploying a project to the SQL Server Integration Services (SSIS) catalog. You need to ensure that the project is deployed to the production environment with the least amount of…
The correct answer is G. Use the Project Deployment Wizard. See the full explanation below for the reasoning.
Question
You are deploying a project to the SQL Server Integration Services (SSIS) catalog. You need to ensure that the project is deployed to the production environment with the least amount of administrative effort. What should you do?
Options
- ACreate an On Error event handler.
- BAdd a data tap on the output of a component in the package data flow.
- CUse the gacutil command.
- DCreate a reusable custom logging component.
- ERun the package by using the dtexecui.exe utility and the SQL Log provider.
- FRun the package by using the dtexec /rep /conn command.
- GUse the Project Deployment Wizard.
- HRun the package by using the dtexec /dumperror /conn command.
- JDeploy the package to the Integration Services catalog by using dtutil and use SQL Server to
How the community answered
(25 responses)- A4% (1)
- B12% (3)
- D8% (2)
- G72% (18)
- J4% (1)
Community Discussion
No community discussion yet for this question.