You have an Azure Synapse Analytics account with a dedicated SQL pool named pool1. The pool1 SQL pool contains a stored procedure with the following characteristics:
- Takes two input parameters
- Returns a set of row data
You need to call the stored procedure from a Synapse pipeline.
What type of activity should you use?
Select only one answer.
- Execute pipeline
- Lookup
- Script
- Stored procedure