DP-203 Certification Practice Question #185

Question

You have an Azure SQL database named DB1 and an Azure Data Factory data pipeline named pipeline1.

From Data Factory, you configure a linked service to DB1.

In DB1, you create a stored procedure named SP1. SP1 returns a single row of data that has four columns.

You need to add an activity to pipeline1 to execute SP1. The solution must ensure that the values in the columns are stored as pipeline variables.

Which two types of activities can you use to execute SP1? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Accepted Answer

Even though the suggested answer and part of the community point to Stored Procedure activity, Microsoft’s own documentation is explicit that when you need returned values or output parameters, you should use Lookup or Script instead. Because SP1 returns a single row with four columns that must be stored as pipeline variables, Lookup and Script are the two activity types that cleanly expose those values to later steps.

More DP-203 practice questions