Microsoft
70-458 · Question #100
70-458 Question #100: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #100. 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. 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.
- JConfigure the SSIS solution to use the Project Deployment Model.
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.