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

Microsoft Exam DP-203 Topic 4 Question 80 Discussion

Actual exam question for Microsoft's DP-203 exam
Question #: 80
Topic #: 4
[All DP-203 Questions]

You have an Azure SQL database named DB1 and an Azure Data Factory data pipeline named pipeline.

From Data Factory, you configure a linked service to DB1.

In DB1, you create a stored procedure named SP1. SP1 returns a single row of data that has four columns.

You need to add an activity to pipeline to execute SP1. The solution must ensure that the values in the columns are stored as pipeline variables.

Which two types of activities can you use to execute SP1? (Refer to Data Engineering on Microsoft Azure documents or guide for Answers/Explanation available at Microsoft.com)

Show Suggested Answer Hide Answer

Contribute your Thoughts:

Shaunna
4 days ago
Yeah, the Lookup activity is more for looking up data from a source and storing it in a variable. I don't think that would be the right fit for executing a stored procedure.
upvoted 0 times
...
Miss
5 days ago
From what I know, the Stored Procedure activity is designed specifically for executing stored procedures in a database, like the one we have here. It should be able to capture the output and store it as pipeline variables.
upvoted 0 times
...
Audry
6 days ago
Sounds good. So, my vote is for the Stored Procedure activity as the correct answer, with the Lookup activity as the other valid option. Anyone disagree?
upvoted 0 times
...
Narcisa
7 days ago
Good point. And the Script activity is more for custom code, not for executing pre-defined stored procedures. So that leaves us with the Stored Procedure and Lookup activities.
upvoted 0 times
...

Save Cancel