
Answer-first summary for fast verification
Answer: Lookup
The 'Lookup' activity in Azure Data Factory is used to execute a stored procedure and retrieve the values it returns. These values can then be made available to downstream activities in the pipeline. The other options such as 'Switch', 'Copy data', and 'Append variable' do not fulfill this requirement. 'Switch' is used for branching, 'Copy data' is used to copy data between data stores, and 'Append variable' is used to append values to an existing variable.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are an administrator for a Fabric tenant and are currently working on developing a pipeline in Azure Data Factory. As part of this pipeline, you have a stored procedure designed to return two specific metrics: the number of active customers and their average sales for the current month. Your goal is to incorporate an activity into the pipeline that will execute this stored procedure within a warehouse environment. Furthermore, it is essential that the values returned by this procedure are accessible to subsequent activities within the pipeline. What type of activity should you add to achieve this functionality?
A
Switch
B
Copy data
C
Append variable
D
Lookup
No comments yet.