QuestionQ85

VerifiedPrepare data

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?

Explanation

The Lookup activity is the correct choice for executing a stored procedure in a warehouse and exposing returned values to downstream activities. Append variable modifies pipeline variables rather than executing queries; Copy data transfers data between sources; KQL is for data queries but doesn't provide the same output-passing mechanism. Lookup is the standard activity for this use case in Fabric Data Factory.

Community Discussion

No comments yet. Be the first to start the discussion!