Microsoft
DP-203 · Question #416
You have an Azure subscription that contains an Azure SQL database named SQL1 and an Azure data factory named ADF1. You need to create a pipeline in ADF1 that will perform the following actions: - Exe
Sign in or unlock DP-203 to reveal the answer and full explanation for question #416. The question stem and answer options stay visible for context.
Submitted by yousef_jo· Mar 30, 2026Develop data processing
Question
You have an Azure subscription that contains an Azure SQL database named SQL1 and an Azure data factory named ADF1. You need to create a pipeline in ADF1 that will perform the following actions:
- Execute a stored procedure to retrieve three configuration values
from SQLI.
- For each value, execute the Set Variable activity.
Which activity should you use to retrieve the configuration values?
Options
- AGet Metadata
- BCopy
- CStored procedure
- 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#pipeline activities#stored procedure#Set Variable