Implementing Analytics Solutions Using Microsoft Fabric — Question 158

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. Get metadata
• B. Switch
• C. Lookup
• D. Append variable

Correct answer: C

Explanation

The correct answer is C, Lookup, because this activity is specifically designed to execute a query or stored procedure and retrieve the results for further use in the pipeline. The other options, such as Get metadata, Switch, and Append variable, do not retrieve data from a stored procedure for downstream processing.