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…

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