HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by
using SQL Server Management Studio.
You need to execute the package and minimize the number of event types that are logged.
Which setting should you use? (To answer, change the appropriate setting in the answer
area.)
Answer: 
Explanation:
Verbose ?
0
0
My fault. I didn’t read carefully – “minimize the number of event types “
0
0
Basic: Warnings and errors
Performance: Includes how long the steps took to execute and is thus unnecessary.
I think its basic
Also, if we just put the all the answers supplied by this site on the test, we’d all fail
0
0
I’ve seen this elsewhere now. It’s performance because while performance also gives you speed of execution and is actually a greater hindrance toward the execution of the package, basic logs all events except custom and diagnostic
0
0
Performance Only performance statistics, and OnError and OnWarning events, are logged.
The Execution Performance report displays Active Time and Total Time for package data flow components. This information is available when the logging level of the last package execution was set to Performance or Verbose. For more information, see Reports for the Integration Services Server.
0
0