DP-203 Certification Practice Question #184

Question

You have an Azure Synapse Analytics dedicated SQL pool.

You need to create a pipeline that will execute a stored procedure in the dedicated SQL pool and use the returned result set as the input for a downstream activity. The solution must minimize development effort.

Which type of activity should you use in the pipeline?

Accepted Answer

The key requirement is not merely executing the stored procedure, but using the returned result set as input to a downstream activity. Microsoft documents that Script activity can execute stored procedures and expose rowsets as activity output, while Stored Procedure activity does not meet that output requirement. That makes Script the lowest-effort option that actually satisfies both conditions.

More DP-203 practice questions