Microsoft
70-463 · Question #171
70-463 Question #171: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #171. The question stem and answer options stay visible for context.
Question
You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job. You make changes to the package that should improve performance. You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal. What should you do?
Options
- AAfter 10 executions, view the job history for the SQL Server Agent job.
- BAfter 10 executions, in SQL Server Management Studio, view the Execution Performance
- CEnable logging to the Application Event Log in the package control flow for the On
- DEnable logging to an XML file in the package control flow for the OnPostExecute event.
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.