You are creating an Azure Data Factory pipeline. You need to add an activity to the pipeline. The activity must execute a Transact-SQL stored procedure that has the following characteristics: • Returns the number of sales invoices for a current date • Does NOT require input parameters Which type on activity should you use?

QuestionsCategory: DP-203You are creating an Azure Data Factory pipeline. You need to add an activity to the pipeline. The activity must execute a Transact-SQL stored procedure that has the following characteristics: • Returns the number of sales invoices for a current date • Does NOT require input parameters Which type on activity should you use?
Admin Staff asked 7 months ago
You are creating an Azure Data Factory pipeline.
You need to add an activity to the pipeline. The activity must execute a Transact-SQL stored procedure that has the following characteristics:
•	Returns the number of sales invoices for a current date
•	Does NOT require input parameters
Which type on activity should you use?

A. Stored Procedure

B. Get Metadata

C. Append Variable

D. Lookup








 

Suggested Answer: D



This question is in DP-203 Data Engineering on Microsoft Azure Exam
For getting Microsoft Certified: Azure Data Engineer Associate Certificate


Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.

Next Post

Recommended

Welcome Back!

Login to your account below

Create New Account!

Fill the forms below to register

Retrieve your password

Please enter your username or email address to reset your password.