Implementing Analytics Solutions Using Microsoft Fabric — Question 126

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. Append variable
• B. Lookup
• C. Copy data
• D. KQL

Correct answer: B

Explanation

The correct answer is B, Lookup, because it is specifically designed to execute a query or stored procedure and retrieve the results for use in later activities. The other options either manipulate or transfer data but do not retrieve values from a stored procedure in a way that allows for subsequent usage in the pipeline.