DP-203 · Question #304
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…
The correct answer is A. Stored Procedure B. Lookup. The two types of activities that you can use to execute SP1 are Stored Procedure and Lookup. A Stored Procedure activity executes a stored procedure on an Azure SQL Database or Azure Synapse Analytics or SQL Server1. You can specify the stored procedure name and parameters in…
Question
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?
Options
- AStored Procedure
- BLookup
- CScript
- DCopy
How the community answered
(53 responses)- A77% (41)
- C8% (4)
- D15% (8)
Explanation
The two types of activities that you can use to execute SP1 are Stored Procedure and Lookup. A Stored Procedure activity executes a stored procedure on an Azure SQL Database or Azure Synapse Analytics or SQL Server1. You can specify the stored procedure name and parameters in the activity settings1. A Lookup activity retrieves a dataset from any data source that returns a single row of data with four columns2. You can use a query to execute a stored procedure as the source of the Lookup activity2. You can then store the values in the columns as pipeline variables by using https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure
Topics
Community Discussion
No community discussion yet for this question.