Implementing Analytics Solutions Using Microsoft Fabric — Question 168

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. Script
• C. Stored procedure
• D. Get metadata

Correct answer: B

Explanation

The correct answer is B, as a Script activity allows you to execute a stored procedure and handle the returned results for further use in the pipeline. Options A and D do not execute procedures and are not suitable for retrieving data. Option C is incorrect because while it is relevant to stored procedures, it does not facilitate the manipulation or handling of the returned values in the context required.