Valid DP-600 Dumps shared by ExamDiscuss.com for Helping Passing DP-600 Exam! ExamDiscuss.com now offer the newest DP-600 exam dumps, the ExamDiscuss.com DP-600 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-600 dumps with Test Engine here:
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?
Correct Answer: C
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. References: The functionality and use of Lookup activity within Azure Data Factory is documented in Microsoft's official documentation for Azure Data Factory, under the section for pipeline activities.
