Microsoft
70-458 · Question #103
70-458 Question #103: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #103. The question stem and answer options stay visible for context.
Question
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system. Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes. You need to establish the best technique to log these invalid rows while minimizing the amount of development effort. What should you do?
Options
- AAdd a data tap on the output of a component in the package data flow.
- BDeploy the package by using an msi file.
- CRun the package by using the dtexecui.exe utility and the SQL Log provider.
- DUses the dtutil /copy command.
- EDeploy the package to the Integration Services catalog by using dtutil and use SQL Server
- FCreate an OnError event handler.
- GUses the Project Deployment Wizard.
- HUse the gacutil command.
- JRun the package by using the dtexec /rep /conn command.
Unlock 70-458 to see the answer
You've previewed enough free 70-458 questions. Unlock 70-458 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.