Implementing Analytics Solutions Using Microsoft Fabric — Question 74

You have a Fabric tenant.

You are creating an Azure 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. Copy data
• C. Append variable
• D. Lookup

Correct answer: D

Explanation

The correct answer is D, Lookup, because it allows you to execute a stored procedure and retrieve the output values for use in subsequent activities. The other options, such as Switch and Copy data, do not support executing stored procedures and obtaining their results, while Append variable is used for modifying variables rather than retrieving data.