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

The correct answer is C. Script. Run stored procedures. If the SQL statement invokes a stored procedure that returns results from a temporary table, use the WITH RESULT SETS option to define metadata for the result set. https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-script

Submitted by andres_qro· Mar 30, 2026Develop data processing

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?

Options

AU-SQL
BStored Procedure
CScript
DNotebook

How the community answered

(39 responses)

A
3% (1)
B
13% (5)
C
79% (31)
D
5% (2)

Explanation

Run stored procedures. If the SQL statement invokes a stored procedure that returns results from a temporary table, use the WITH RESULT SETS option to define metadata for the result set. https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-script

Topics

#Script activity#stored procedure#dedicated SQL pool#pipeline result set

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice