QuestionQ107

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 appropriate choice for executing a stored procedure in a warehouse and making the returned values available to downstream pipeline activities. Get metadata retrieves object properties; Copy data transfers data between sources but doesn't easily expose output; Append variable modifies pipeline variables. Only Lookup is designed to execute queries/procedures and expose results to downstream activities.

Community Discussion

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