You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is r

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is r

Post by answerhappygod »

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 OnPostExecute event. After 10 executions, view the XML file.
B. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the project.
C. Enable logging to the Application Event Log in the package control flow for the OnInformation event. After 10 executions, view the Application Event Log.
D. Configure the package to send you an email upon completion that includes information about the duration of the package. After 10 executions, view the emails.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply