70-463 · Question #50
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. The Project Deployment Wizard provides a guided, step-by-step interface to deploy SSIS projects directly to the SSISDB catalog with the least administrative effort.
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.
- IUse the dtutil/copy command.
- JDeploy the package to the Integration Services catalog by using dtutil and use SQL Server
How the community answered
(26 responses)- F8% (2)
- G88% (23)
- I4% (1)
Why each option
The Project Deployment Wizard provides a guided, step-by-step interface to deploy SSIS projects directly to the SSISDB catalog with the least administrative effort.
An OnError event handler responds to runtime errors inside a package design and does not perform project deployment.
A data tap captures intermediate data flow output for temporary debugging and plays no role in deploying a project.
gacutil registers custom .NET assemblies in the GAC and is used for custom component installation, not SSIS project deployment.
Creating a reusable custom logging component is a development-time design task that increases effort rather than reducing it.
dtexecui.exe provides an interactive UI for executing packages but cannot deploy projects to the SSIS catalog.
dtexec /rep /conn executes a package and reports connection-based results but does not deploy projects.
The Project Deployment Wizard, launched from SQL Server Management Studio or by opening an .ispac file, automates all steps of deploying a project to the SSIS catalog including connection setup, project selection, and validation - making it the lowest-effort method and the standard tool for SSISDB project deployment.
dtexec /dumperror /conn runs a package with error dump generation and has no deployment capability.
dtutil /copy copies individual package files between storage locations but cannot deploy a full project to the SSISDB catalog.
Deploying via dtutil to the catalog involves manual command-line steps and connection configuration, requiring more administrative effort than the wizard.
Concept tested: SSIS Project Deployment Wizard for SSISDB catalog deployment
Source: https://learn.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages
Topics
Community Discussion
No community discussion yet for this question.