Multiple choice technology

Sequence Generator Transformation is

  1. Active/ Connected

  2. Passive/ Connected

  3. Passive/ Unconnected

  4. Active or Passive depends of the session property/Connected
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The correct answer is B (Passive/Connected) because a Sequence Generator transformation is Passive (it doesn't change the number of rows passing through it) and Connected (it must be connected to the data flow - it cannot be used unconnected like a Lookup transformation). It generates sequence values but doesn't filter, aggregate, or otherwise modify the row count.

Keep practicing — related questions