Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have an Azure Synapse Analytics account with a dedicated SQL pool named pool 1 . The pool 1 SQL pool contains a stored procedure

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Formal SQL Tuning For Oracle Databases Practical Efficiency Efficient Practice

Authors: Leonid Nossov ,Hanno Ernst ,Victor Chupis

1st Edition

3662570564, 978-3662570562

More Books

Students also viewed these Databases questions