In the Fabric data pipeline UI, which type of activity supports parameterization (allowing you to pass runtime values)?

In the Fabric data pipeline UI, which type of activity supports parameterization (allowing you to pass runtime values)?

• A. Dataflow Gen2
• B. SQL stored procedures
• C. notebooks
• D. user-defined functions

Answer: (B)

Parameterization means feeding values that are determined only when the pipeline runs. SQL stored procedures are built to accept input parameters, so the pipeline can pass actual runtime values into the procedure call. This makes them the most direct and reliable way to supply dynamic values from the pipeline at execution time. Other options can involve parameters in their own contexts, but they don’t provide the same straightforward activity-level parameter passing as SQL stored procedures.

Parameterization means feeding values that are determined only when the pipeline runs. SQL stored procedures are built to accept input parameters, so the pipeline can pass actual runtime values into the procedure call. This makes them the most direct and reliable way to supply dynamic values from the pipeline at execution time. Other options can involve parameters in their own contexts, but they don’t provide the same straightforward activity-level parameter passing as SQL stored procedures.