Multiple choice technology databases

Stroed Procedure is --- transformation.

  1. Connected

  2. Unconnected

  3. Passive

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

Stored Procedure transformation can be either Connected or Unconnected, and it's Passive in nature. As Connected, it participates in the data flow and receives input from the pipeline. As Unconnected, it's called from an expression and returns values. It's Passive because it doesn't change the number of rows passing through - it executes a database procedure but doesn't transform row count. Therefore 'All' is correct.

Keep practicing — related questions