Microsoft
70-463 · Question #5
70-463 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
Configure and deploy SSIS solutions
Question
You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database. The project uses the Package Deployment Model. This project is deployed to SQL Server on a test server. You need to ensure that the project is deployed to the SSIS catalog on the production server. What should you do?
Options
- AOpen a command prompt and run the dtexec/dumperror/conn command.
- BCreate a reusable custom logging component and use it in the SSIS project.
- COpen a command prompt and run the gacutil command.
- DAdd an OnError event handler to the SSIS project.
- EOpen a command prompt and execute the package by using the SQL Log provider and
- FOpen a command prompt and run the dtexec/rep/conn command.
- GOpen a command prompt and run the dtutil/copy command.
- HUse an msi file to deploy the package on the server.
- 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.
Topics
#SSIS deployment#Project Deployment Model#SSIS catalog#package migration