Data Engineering on Microsoft Azure — Question 103

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?

Answer options

• A. Stored Procedure
• B. Get Metadata
• C. Append Variable
• D. Lookup

Correct answer: D

Explanation

The correct answer is D, Lookup, as it is specifically designed to retrieve data from a data source and can execute stored procedures that return data. The other options, such as Stored Procedure and Append Variable, do not align with the requirement of executing a procedure that returns a result set without needing input parameters.