Microsoft
70-463 · Question #154
70-463 Question #154: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #154. The question stem and answer options stay visible for context.
Question
You are deploying a new SQL Server Integration Services (SSIS) package to five 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 and redeploying the package. - The deployment procedure must be automated as much as possible. - Performance must be maximized. You need to set up a deployment strategy that meets the requirements. What should you do?
Options
- AAdd an OnError event handler to the SSIS project.
- BUse an msi file to deploy the package on the server.
- COpen a command prompt and run the gacutil command.
- DOpen a command prompt and run the dtutil/copy command.
- EOpen a command prompt and run the dtexec/rep/conn command.
- FOpen a command prompt and run the dtexec/dumperror/conn command.
- GOpen a command prompt and execute the package by using the SQL Log provider and
- HCreate a reusable custom logging component and use it in the SSIS project.
- IConfigure the SSIS solution to use the Project Deployment Model.
- JConfigure the output of a component in the package data flow to use a data tap.
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.