Discuss Microsoft DP-600 Exam Topic 3 Question 39

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

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.

Get Premium DP-600 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

33 comments · newest first

Deja 10 months ago

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

Johnetta 10 months ago

Totally agree, Script is the way to go!

Vincenza 10 months ago

You need to use a Script activity for that.

Tegan 11 months ago

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

Asha 11 months ago

Append variable? Seems off for this scenario.

Tamar 11 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.

Louvenia 11 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.

Rolland 11 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.

Lonny 12 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.

Billi 12 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!

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

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

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

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

Alyce 1 year ago

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

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!

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?

Gerald 1 year ago

↳ replying to Rebeca

B) Copy data

Scarlet 1 year ago

↳ replying to Rebeca

A) Script

Brent 1 year ago

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

Charlette 1 year ago

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

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.

Marti 1 year ago

↳ replying to Victor

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

Millie 1 year ago

↳ replying to Victor

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

Amber 1 year ago

↳ replying to Victor

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

Melvin 1 year ago

I think the answer is A) Script.

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.

King 1 year ago

↳ replying to Filiberto

Copy data seems like the most practical option to ensure the values from the stored procedure are available for downstream activities.

Valentine 1 year ago

↳ replying to Filiberto

I agree, using Copy data will make the returned values accessible for the rest of the pipeline.

Felicidad 1 year ago

↳ replying to Filiberto

B) Copy data sounds like the right choice. It can help transfer the results from the stored procedure to the downstream activities.

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

Phung 1 year ago

↳ replying to Andra

User 2: Yeah, executing a stored procedure is like running a custom script.

Alisha 1 year ago

↳ replying to Andra

User 1: I think A) Script is the way to go.

Microsoft DP-600 Exam - Topic 3 Question 39 Discussion