Microsoft
DP-203 · Question #401
You are creating an Azure Data Factory pipeline. You need to add an activity to the pipeline. The activity must execute a Transact-SQL stored procedure that has the following characteristics…
The correct answer is D. Lookup. The Stored Procedure Activity does not allow to return an output, so Lookup is the correct one. https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure
Submitted by ahmad_uae· Mar 30, 2026Develop data processing
Question
You are creating an Azure Data Factory pipeline. You need to add an activity to the pipeline. The activity must execute a Transact-SQL stored procedure that has the following characteristics:
- Returns the number of sales invoices for a current date
- Does NOT require input parameters
Which type on activity should you use?
Options
- AStored Procedure
- BGet Metadata
- CAppend Variable
- DLookup
How the community answered
(29 responses)- A7% (2)
- B3% (1)
- C7% (2)
- D83% (24)
Explanation
The Stored Procedure Activity does not allow to return an output, so Lookup is the correct one. https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure
Topics
#ADF Lookup activity#stored procedure#pipeline activity types#return values
Community Discussion
No community discussion yet for this question.