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.)
Which setting should you use?
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.)
The answer appears to be correct according to this link;
https://msdn.microsoft.com/en-us/library/hh231191.aspx
Must be basic. The Performance will also give you additional data on how long the task took
You need to execute the package and “”minimize the number of event types that are logged””””!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
https://msdn.microsoft.com/en-us/library/hh231191.aspx
-_-‘
http://www.mattmasson.com/2011/12/what-events-are-included-in-the-ssis-catalog-log-levels/
Of course now that I look at it, it’s a toss up. There is no logging level that just shows on error and onwarning data. The Basic shows all events and the performance also shows the actual performance data of the different data flow components. I guess if you’re most interested in the unimportant goal of logging the least number of different events it would be performance because while it logs less events, there is more overhead because the data it does log takes longer to accumulate. Again a real world goal would be either logging to tune the ssis or logging to accomodate basic everyday function. Stupid question.
It will be “Performance” because:
1) “Performance” mode just logs 2 events OnError and OnWarning. By the way, there are hell lot of events like OnPreExecute, OnPostExecute, OnQueryCancel, OnExecStatusChanged, etc. This question asks specifically “minimize the number of event types that are logged”
2) “Basic” mode logs all events.
Reference: https://docs.microsoft.com/en-gb/sql/integration-services/performance/integration-services-ssis-logging