Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam DP-600 Topic 3 Question 39 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 39
Topic #: 3
[All DP-600 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

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.


by Gwenn at Jul 12, 2025, 01:58 PM

Limited Time Offer

25%

Off

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Rebeca
3 hours ago
Ha! This question is a real brain-teaser. I bet the answer is C) Switch, because that's always the right choice, isn't it?
upvoted 0 times
...
Brent
1 days ago
I'm not sure. Maybe B) Copy data could also work to get the values into the warehouse.
upvoted 0 times
...
Charlette
2 days ago
I agree with Melvin. Using a script activity makes sense for executing the stored procedure.
upvoted 0 times
...
Victor
4 days ago
Hmm, I'm not sure. Maybe D) Append variable? That way you can store the returned values in a variable and use them later in the pipeline.
upvoted 0 times
...
Melvin
6 days ago
I think the answer is A) Script.
upvoted 0 times
...
Filiberto
8 days ago
I'm thinking B) Copy data might work here. You can copy the results from the stored procedure to a dataset, and then use that in the downstream activities.
upvoted 0 times
...
Andra
19 days ago
Definitely gotta go with A) Script. Executing a stored procedure is like a custom script, right? That's the way to go for sure.
upvoted 0 times
Alisha
7 days ago
User 1: I think A) Script is the way to go.
upvoted 0 times
...
...

Save Cancel