ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 176 discussion

Actual exam question from Microsoft's DP-600
Question #: 176
Topic #: 1
[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?

  • A. Append variable
  • B. Script
  • C. Stored procedure
  • D. Get metadata
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Azure_2023 at March 12, 2025, 3:26 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Lotusss
1 week 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 2 times
...
4e5cf3d
2 weeks, 5 days 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 2 times
hecke
4 days, 16 hours ago
To back this, here is the source: https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure
upvoted 1 times
...
...
wudixh
1 month 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
...
nvukas
1 month ago
Selected Answer: B
Script or lookup
upvoted 1 times
nvukas
1 month ago
I was wrong https://learn.microsoft.com/en-us/fabric/data-factory/stored-procedure-activity
upvoted 1 times
...
...
Azure_2023
1 month, 1 week 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago