Microsoft
70-463 · Question #4
70-463 Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
Question
To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is put in place. The methodology has the following requirements: - The deployment process must be simplified. - All the logs must be centralized in SQL Server. - Log data must be available via reports or T-SQL. - Log archival must be automated. You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort. What should you do?
Options
- AOpen a command prompt and run the gacutil command.
- BOpen a command prompt and execute the package by using the SQL Log provider and
- CAdd an OnError event handler to the SSIS project.
- DUse an msi file to deploy the package on the server.
- EConfigure the output of a component in the package data flow to use a data tap.
- FRun the dtutil command to deploy the package to the SSIS catalog and store the
- GOpen a command prompt and run the dtexec/rep/conn command.
- HOpen a command prompt and run the dtutil/copy command.
- IOpen a command prompt and run the dtexec/dumperror/conn command.
- JConfigure the SSIS solution to use the Project Deployment Model.
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.