DP-203 · Question #324
DP-203 Question #324: Real Exam Question with Answer & Explanation
The correct answer is B: Lookup. Lookup activity reads and returns the content of a configuration file or table. It also returns the result of executing a query or stored procedure. The output can be a singleton value or an array of attributes, which can be consumed in a subsequent copy, transformation, or contr
Question
You have an Azure subscription that contains an Azure SQL database named DB1 and a storage account named storage1. The storage1 account contains a file named File1.txt. File1.txt contains the names of selected tables in DB1. You need to use an Azure Synapse pipeline to copy data from the selected tables in DB1 to the files in storage1. The solution must meet the following requirements: - The Copy activity in the pipeline must be parameterized to use the data in File1.txt to identify the source and destination of the copy. - Copy activities must occur in parallel as often as possible. Which two pipeline activities should you include in the pipeline? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- AGet Metadata
- BLookup
- CForEach
- DIf Condition
Explanation
Lookup activity reads and returns the content of a configuration file or table. It also returns the result of executing a query or stored procedure. The output can be a singleton value or an array of attributes, which can be consumed in a subsequent copy, transformation, or control flow activities like ForEach activity. https://learn.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity
Community Discussion
No community discussion yet for this question.