QuestionQ69

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 in Fabric Data Factory is specifically designed to execute stored procedures or queries and capture their results for use by downstream activities. It retrieves a small set of values (such as the count and average from your stored procedure) and makes them available as activity output variables that subsequent activities can reference and act upon.

Community Discussion

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