DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

By Microsoft · Question Mode

QuestionQ12

Prepare data

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?

  • A Append variable
  • B Script
  • C Stored procedure
  • D Get metadata
Explanation

The Stored Procedure activity in a Fabric Data Factory pipeline does not support surfacing output parameter values to downstream activities. To run a procedure and make its returned values available to later steps in the pipeline, you use the Script activity, which can execute the procedure and expose its result set/output for downstream consumption.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!