Microsoft
70-458 · Question #108
70-458 Question #108: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #108. 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 ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology. The methodology has the following requirements: - Centralized logging in SQL Server - Simple deployment - Availability of log information through reports or T-SQL ?Automatic purge of older log entries - Configurable log details 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
- AUse the gacutil command.
- BUse the dtutil /copy command.
- CUse the Project Deployment Wizard.
- DCreate an OnError event handler.
- ECreate a reusable custom logging component.
- FRun the package by using the dtexec /rep /conn command.
- GRun the package by using the dtexec /dumperror /conn command.
- HRun the package by using the dtexecui.exe utility and the SQL Log provider.
- JDeploy the package by using an msi file.
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.