You need to use the least amount of administrative effort to achieve this goal

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?

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?

A.
Enable logging to an XML file in the package control flow for the Onlnformation event.
After 10 executions, view the XML file.

B.
After 10 executions, view the job history for the SQL Server Agent job.

C.
After 10 executions, in SQL Server Management Studio, view the Execution Performance
subsection of the All Executions report for the package.

D.
Enable logging to an XML file in the package control flow for the OnPostExecute event.
After 10 executions, view the XML file.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Jass

Jass

Right answer as this is the best way to see the executions reports of the packages