Multiple choice technology

Which type of tracing level writes the log for every row of data, hence slows down the data load performance?

  1. Normal

  2. Terse

  3. Verbose Initialization

  4. Verbose data
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Tracing levels control logging granularity. Normal provides basic info, Terse gives minimal logging, Verbose Initialization logs startup details. Verbose Data writes a log entry for EVERY single row processed, which creates maximum overhead and significantly slows data loading performance. This level is typically used only for debugging specific row-level issues.

Keep practicing — related questions