MDFT Academy Quizzes

Choose the Activity Type for Stored Procedure Execution

You work for MDFT Academy, a well-known training agency. You are creating a Fabric Data Factory pipeline for the academy’s data processing needs. You have a stored procedure that returns the number of active students and their average course purchases 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?

Choose the correct answer from the options below.

Explanations for each answer:

Switch is incorrect. A Switch activity is used for conditional branching in a pipeline based on conditions, similar to a switch statement in programming. It cannot execute stored procedures or return data to downstream activities.
Lookup is correct.
Append Variable is incorrect. An Append Variable activity is used to add a value to an existing array variable in a pipeline. It cannot execute stored procedures or retrieve data from a warehouse.
KQL is incorrect. A KQL activity is used to execute Kusto Query Language queries against Azure Data Explorer or Log Analytics. It is not designed to execute SQL stored procedures in a warehouse.

Exam Preparation Quiz

Choose the Activity Type for Stored Procedure Execution