DP-203 Certification Practice Question #205

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?

Accepted Answer

The requirement is not just to execute a stored procedure, but to retrieve three returned configuration values and feed each value into Set Variable activities. Microsoft Learn documents Lookup as the ADF activity that can call a query or stored procedure, return a result set, and expose that output to downstream expressions. That makes Lookup the right bridge between SQL output and Set Variable logic. The Stored Procedure activity is for execution, not for returning a dataset to later activities.

More DP-203 practice questions