Exam DP-203 topic 2 question 113 discussion

https://learn.microsoft.com/en-us/answers/questions/925742/how-to-process-output-from-stored-procedure-in-azu SP Activity does not capture result.. use lookup instead of script

why not CD? A Lookup activity can be used to execute a query or stored procedure against a data source and retrieve a single row of data. The returned values can then be stored as pipeline variables and used in subsequent activities. A Stored Procedure activity can be used to directly execute a stored procedure against a data source. The returned values can be captured as output parameters and stored as pipeline variables for use in subsequent activities.

When the stored procedure has Output parameters, instead of using stored procedure activity, use lookup acitivty and Script activity. Stored procedure activity does not support calling SPs with Output parameter yet. https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure

correct answers are A and C "When the stored procedure has Output parameters, instead of using stored procedure activity, use lookup acitivty and Script activity. Stored procedure activity does not support calling SPs with Output parameter yet. If you call a stored procedure with output parameters using stored procedure activity, following error occurs. Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 201. Error Message: Procedure or function 'sp_name' expects parameter '@output_param_name', which was not supplied." https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure

correct answer is C and D

AC cannot capture SP output params with sP activity

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. https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-script

A. Script & C. Lookup are the correct answers Incorrect D.Stored procedure activity doesn't return any values. B.Copy Activity is meant for copying data only

Script lookup

Here is an example of how we can use the Script activity to execute SP1: Script activity (name: "ExecuteSP1Script") { ScriptSource = "<![CDATA[ var results = SqlCommand('EXEC SP1', connection); var myVar = results[0]; ]]>" } In this example, the ScriptSource property specifies the script that is used to execute SP1. The script first executes the SQL statement EXEC SP1. The script then stores the results of SP1 in the variable myVar. Correct Answers are: A & D

is correct

sorry, Answer - AC

Answer is wrong - https://learn.microsoft.com/en-us/answers/questions/925742/how-to-process-output-from-stored-procedure-in-azu Answer is CD. SP act cannot emit result..

CD is the rite answer

https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-script

C. Lookup D. Stored Procedure Explanation: C. Lookup: The Lookup activity is used to retrieve a dataset from a data source and the output can be used in subsequent activities. It is often used to fetch a small amount of data to be used as parameters in other activities. In this case, it can be used to execute the stored procedure and capture the result into pipeline variables. D. Stored Procedure: The Stored Procedure activity is used specifically to execute stored procedures. You can capture the output of the stored procedure and assign it to pipeline variables. This activity is designed specifically for executing stored procedures, making it a direct option for this requirement. A. Script: There is no "Script" activity in Azure Data Factory. B. Copy: The Copy activity is primarily used for copying data from a source to a destination and is not suitable for executing a stored procedure and capturing its output into pipeline variables.

I think the correct answer is C and D.