Implementing Analytics Solutions Using Microsoft Fabric — Question 123

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

Correct answer: C

Explanation

The correct answer is C, Lookup, because this activity is specifically designed to execute a stored procedure and retrieve its output for use in later activities within the pipeline. The other options do not serve this purpose; Get metadata is for fetching information about datasets, Copy data is for transferring data between sources, and Append variable is used for modifying variable values, not for executing procedures.