Microsoft DP-600 Exam - Topic 3 Question 39 Discussion

Actual exam question for Microsoft's DP-600 exam

Question #: 39
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?

AScript

BCopy data

CSwitch

DAppend variable

Show Suggested 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

Deja

8 months ago

Wait, can you really get values from a stored procedure like that?

upvoted 0 times

...

Johnetta

9 months ago

Totally agree, Script is the way to go!

upvoted 0 times

...

Vincenza

9 months ago

You need to use a Script activity for that.

upvoted 0 times

...

Tegan

9 months ago

I thought Copy data might work too, but not sure now.

upvoted 0 times

...

Asha

9 months ago

Append variable? Seems off for this scenario.

upvoted 0 times

...

Tamar

9 months ago

I don't recall seeing Switch or Append variable used for executing stored procedures, so I think we can rule those out. It must be either Script or Copy data.

upvoted 0 times

...

Louvenia

10 months ago

I'm a bit confused about the difference between Script and Copy data. I feel like Copy data is more for transferring data rather than executing a procedure.

upvoted 0 times

...

Rolland

10 months ago

I remember practicing a similar question where we had to execute a stored procedure, and I think it was the Script activity that worked best for that.

upvoted 0 times

...

Lonny

10 months ago

I think we need to use an activity that can execute SQL commands, but I'm not entirely sure if it's the Script or Copy data option.

upvoted 0 times

...

Billi

10 months ago

Okay, I think I've got this. The Script activity is the right choice to execute the stored procedure and pass the results to the downstream activities. Time to put my thinking cap on and nail this question!

upvoted 0 times

...

Martina

10 months ago

I'm leaning towards the Append variable option. That seems like it would be the easiest way to get the stored procedure data into the pipeline. But I'm not 100% sure, so I might need to double-check the details.

upvoted 0 times

...

Elin

11 months ago

Ah, I see what they're asking for. The Script activity is the way to go here. That will let me run the stored procedure and make the results available to the rest of the pipeline.

upvoted 0 times

...

Delisa

11 months ago

I'm a bit confused here. Should I use the Copy data activity instead to move the data from the stored procedure to the pipeline? I'm not sure which option is the best fit.

upvoted 0 times

...

Laurel

11 months ago

Hmm, this looks like a tricky one. I think I'll go with Script to execute the stored procedure and get the data I need for the downstream activities.

upvoted 0 times

...

Alyce

1 year ago

I think A) Script is the best option because it allows for more flexibility in executing the stored procedure.

upvoted 0 times

...

Martina

1 year ago

A) Script, for sure. It's the only option that lets you run custom code, which is what you need to execute a stored procedure. Easy peasy!

upvoted 0 times

...

Rebeca

1 year 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

Gerald

11 months ago

B) Copy data

upvoted 0 times

...

Scarlet

12 months ago

A) Script

upvoted 0 times

...

Brent

1 year ago

I'm not sure. Maybe B) Copy data could also work to get the values into the warehouse.

upvoted 0 times

...

Charlette

1 year ago

I agree with Melvin. Using a script activity makes sense for executing the stored procedure.

upvoted 0 times

...

Victor

1 year 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

Marti

11 months ago

C) Switch might be a good choice to handle different scenarios based on the returned values.

upvoted 0 times

...

Millie

11 months ago

I would go with B) Copy data to ensure the returned values are available to downstream activities.

upvoted 0 times

...

Amber

12 months ago

I think A) Script would be a better option to execute the stored procedure.

upvoted 0 times

...

Melvin

1 year ago

I think the answer is A) Script.

upvoted 0 times

...

Filiberto

1 year 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