Free Preparation Discussions
MENU
Microsoft Exam DP-600 Topic 3 Question 39 Discussion
Topic #: 3
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?
In a Fabric Data Factory pipeline, to execute a stored procedure and make the returned values available for downstream activities, the Lookup activity is used. This activity can retrieve a dataset from a data store and pass it on for further processing. Here's how you would use the Lookup activity in this context:
Add a Lookup activity to your pipeline.
Configure the Lookup activity to use the stored procedure by providing the necessary SQL statement or stored procedure name.
In the settings, specify that the activity should use the stored procedure mode.
Once the stored procedure executes, the Lookup activity will capture the results and make them available in the pipeline's memory.
Downstream activities can then reference the output of the Lookup activity.
Currently there are no comments in this discussion, be the first to comment!