Fabric Data Factory Stored Procedure Activity

DP-600 By islever Editorial Last updated

Maintain the analytics development lifecycle

Short answer

D Add a Lookup activity to execute the stored procedure and make the returned values available to downstream activities.

Question

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?
  1. Switch
  2. KQL
  3. Append variable
  4. Lookup Correct Answer

Key Takeaways

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.

Common mistake: 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.

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

https://learn.microsoft.com/en-us/fabric/data-factory/lookup-activity

This link opens the official vendor documentation in a new tab.

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.

Community Votes

D
100%

100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 4 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors, not of islever. The comments shown first are the most substantive of the thread — ranked by depth, community endorsement and relevance; expand the list below to read the rest.

From public community threads 4

  1. Pegooli 👍 3
    D is correct - A Lookup activity in Fabric Data Factory is specifically designed to execute a query or stored procedure and retrieve data from a data source.
  2. nappi1 👍 2 Answered D
    to execute a stored procedure in a Fabric Data Factory pipeline and make the returned values available for downstream activities, you should use the Lookup activity. the Lookup activity allows you to execute a query or stored procedure and retrieve the results, which can then be used in subsequent activities within the pipeline.
  3. 2fe10ed 👍 2 Answered D
    Script or Lookup activity https://learn.microsoft.com/en-us/fabric/data-factory/lookup-activity https://blog.fabric.microsoft.com/id-id/blog/automate-fabric-data-warehouse-queries-and-commands-with-data-factory?ft=All
  4. nappi1 👍 1 Answered D
    Lookup is correct

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Fabric Deployment Pipeline Folder Structure Behavior

S-grade

Accessing OneLake Shortcuts in Fabric Notebooks

S-grade

Direct Lake Fallback to DirectQuery with Row-Level Security

S-grade

Displaying All Rows in Power BI Python Visuals

S-grade

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide