Find the best solutions to your problems with the help of IDNLearn.com. Discover reliable and timely information on any topic from our network of knowledgeable professionals.

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