Microsoft
70-463 · Question #54
70-463 Question #54: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.
Question
You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL Azure database into a data warehouse. The source system contains redundant or inconsistent data. When the package finds invalid data, the row containing the invalid data must be omitted but it must also be written to a text file for further analysis. You need to establish the best technique to log these invalid rows while keeping the amount of development effort to a minimum. What should you do?
Options
- AAdd an OnError event handler to the SSIS project.
- BOpen a command prompt and execute the package by using the SQL Log provider and
- CUse an msi file to deploy the package on the server.
- DOpen a command prompt and run the gacutil command.
- ERun the dtutil command to deploy the package to the SSIS catalog and store the
- FOpen a command prompt and run the dtutil/copy command.
- GCreate a reusable custom logging component and use it in the SSIS project.
- HConfigure the SSIS solution to use the Project Deployment Model.
- IConfigure the output of a component in the package data flow to use a data tap.
- JOpen a command prompt and run the dtexec/rep/conn command.
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.