Implementing Analytics Solutions Using Microsoft Fabric — Question 116

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?

Answer options

• A. Switch
• B. KQL
• C. Append variable
• D. Lookup

Correct answer: D

Explanation

The correct answer is D, Lookup, as it is specifically designed to execute a stored procedure and retrieve its output for use in downstream activities. The other options do not provide the functionality to execute a stored procedure and return values; for instance, Switch is used for conditional branching, KQL is for querying data, and Append variable simply adds to a variable without executing a procedure.