Microsoft
70-463 · Question #207
70-463 Question #207: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #207. The question stem and answer options stay visible for context.
Question
You are deploying a new SQL Server Integration Services (SSIS) package to several servers. The package must meet the following requirements: - .NET Common Language Runtime (CLR) integration in SQL Server must not be enabled. - The Connection Managers used in the package must be configurable without editing the package. - The deployment procedure must be automated as much as possible. You need to set up a deployment strategy that meets the requirements. What should you do?
Options
- AUse the gacutil command.
- BUse the dtutil/copy command.
- CUse the Project Deployment Wizard.
- DCreate an OnError event handler.
- ECreate a reusable custom logging component.
- FRun the package by using the dtexec/rep/conn command.
- GRun the package by using the dtexec/dumperror/conn command.
- HRun the package by using the dtexecui.exe utility and the SQL Log provider.
- IAdd a data tap on the output of a component in the package data flow.
- JDeploy the package by using an msi file.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.