BenchMark Quizzes by MDFT Pro

Choose the Correct Activity for Executing a Stored Procedure

You work for MDFT Pro, a well-known training agency. You have a Fabric tenant and 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. The returned values must be available to the downstream activities of the pipeline.

Which activity should you add?

Choose the correct answer from the options below.

Explanations for each answer:

Get Metadata is incorrect. The Get Metadata activity is used to retrieve metadata about data in various sources, such as file names, sizes, or column information. It cannot execute stored procedures or return result sets.
Copy Data is incorrect. The Copy Data activity is designed to copy data between source and destination data stores. While it can read from a database, it cannot execute stored procedures or return result sets.
Lookup is correct.
Append Variable is incorrect. The Append Variable activity is used to add values to an existing array variable in the pipeline. It cannot execute stored procedures or interact with databases directly.

Learn more about Lookup activity in Fabric pipelines:

Lookup Activity

Exam Preparation Quiz

Choose the Correct Activity for Executing a Stored Procedure