DP-203 Certification Practice Question #198

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?

Accepted Answer

The requirement is not just to invoke a procedure but to get back the count of invoices for the current date so the pipeline can use that returned value. Microsoft Learn explicitly says Lookup can execute a query or stored procedure and return the result set to downstream activities. By contrast, Stored Procedure activity is for invocation and is not the preferred mechanism when you need to capture returned values in pipeline flow. That aligns with both the suggested answer and the community consensus.

More DP-203 practice questions