Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 176 discussion

Actual exam question from Microsoft's DP-600

Question #: 176
Topic #: 1

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?

A. Append variable
B. Script
C. Stored procedure
D. Get metadata

Show Suggested Answer

Suggested Answer: B 🗳️

by Azure_2023 at March 12, 2025, 3:26 p.m.

Comments

Submit Cancel

4e5cf3d

Highly Voted 2 months, 1 week ago

Selected Answer: B

"When the stored procedure has Output parameters, instead of using stored procedure activity, use lookup activity and Script activity. Stored procedure activity does not support calling SPs with Output parameter yet." Literally on MS documentation

upvoted 6 times

hecke

1 month, 3 weeks ago

To back this, here is the source: https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure

upvoted 2 times

...

PradeepikaGadai

Most Recent 1 week, 6 days ago

Selected Answer: B

The Script activity in Fabric (and in Synapse-style pipelines) is used to run T-SQL code including EXEC stored_procedure_name, and capture output from the executed SQL.

upvoted 1 times

...

Lotusss

1 month, 3 weeks ago

Selected Answer: C

Script activity offers flexibility and can execute stored procedures, it is more suited for scenarios where you need to combine multiple SQL operations or handle complex workflows. For this specific task, the Stored Procedure activity is more efficient and purpose-built.

upvoted 3 times

...

wudixh

2 months, 2 weeks ago

Selected Answer: C

According to MS Copilot: To execute the stored procedure and make the returned values available to downstream activities in your Fabric Data Factory pipeline, you should add a Stored procedure activity (option C). This activity is specifically designed to execute stored procedures in a database and can pass the output to subsequent activities in the pipeline.

upvoted 3 times

Sr18

3 weeks, 1 day ago

Copilot is stupid, it means that you can take status forward. Script or Lookup.

upvoted 1 times

...

nvukas

2 months, 3 weeks ago

Selected Answer: B

Script or lookup

upvoted 2 times

nvukas

2 months, 3 weeks ago

I was wrong https://learn.microsoft.com/en-us/fabric/data-factory/stored-procedure-activity

upvoted 1 times

...

Azure_2023

2 months, 3 weeks ago

Selected Answer: B

Not sure in what scenario I would use Script activity over lookup, but considering we do not have Lookup as an answer here, we are left with Script as the answer. Stored Procedure activity does not return any values.

upvoted 2 times

...