nerdexam
Microsoft

DP-203 · Question #324

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

Sign in or unlock DP-203 to reveal the answer and full explanation for question #324. The question stem and answer options stay visible for context.

Submitted by daniela_cl· Mar 30, 2026Develop data processing

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

Unlock DP-203 to see the answer

You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Azure Data Factory#Lookup activity#ForEach activity#parameterized pipeline
Full DP-203 Practice