Fabric Data Factory Stored Procedure Activity
You have a Fabric tenant. You are creating a Fabric Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the current month. You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline. Which type of activity should you add?
Community Votes
100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
The Lookup activity is specifically designed to execute a query or stored procedure and capture its result set for downstream consumption, whereas other activities like Script do not output data in the same structured way.
The Lookup activity in Fabric Data Factory is used to execute a stored procedure or query and retrieve its output. This page confirms why the Lookup activity is the correct choice for passing returned values to downstream pipeline activities.
Choosing the Script activity because it can execute code, but failing to recognize that only the Lookup activity is explicitly designed to return rowsets for downstream pipeline consumption.
Community Discussion (4 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
The Lookup activity in Fabric Data Factory is explicitly designed to execute a query or stored procedure against a data source like a warehouse and retrieve the results. Its primary purpose is to make this returned data available to downstream activities in the pipeline, which perfectly matches the requirement in the question.Why the Other Options Are Wrong
The Switch activity is used for routing and conditional branching based on expressions, not for executing queries. The KQL activity is specifically for running Kusto Query Language (KQL) queries against a KQL database, not a stored procedure in a warehouse. The Append variable activity is used to add a value to an existing array variable, not to execute a stored procedure and capture its output.Community Comment Notes
Commenters agree that the Lookup activity is the correct choice because it can execute a stored procedure and retrieve the results for downstream use. As one user noted, the Lookup activity "allows you to execute a query or stored procedure and retrieve the results," which aligns with the official documentation linked in the comments.Official Reference
Exam Strategy
When a pipeline requires executing a query or stored procedure and passing the results to subsequent activities, choose the Lookup activity. Remember that Lookup is uniquely suited for returning data to the pipeline, unlike the Script activity which is primarily for execution without structured downstream output.
Related Analysis
Practice All DP-600 Questions
Access 115 questions with complete answers and detailed explanations.
View Full DP-600 Practice Test →