Microsoft Azure Data Engineer Associate - DP-203

Microsoft Azure Data Engineer Associate - DP-203

Get started today

Ultimate access to all questions.


You have an Azure SQL database named DB1 and an Azure Data Factory pipeline named pipeline1. A linked service to DB1 is configured in Data Factory.

A stored procedure named SP1 is created in DB1. SP1 returns a single row of data containing four columns.

You need to add an activity to pipeline1 to execute SP1. The column values from the result must be stored as pipeline variables.

Which two activity types can you use to execute SP1? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.




Comments

Loading comments...