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)
the two types of activities that you can use to execute SP1 areStored ProcedureandLookup.
https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure
Currently there are no comments in this discussion, be the first to comment!