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: - Return
Sign in or unlock DP-203 to reveal the answer and full explanation for question #401. The question stem and answer options stay visible for context.
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
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#ADF Lookup activity#stored procedure#pipeline activity types#return values