nerdexam
Microsoft

DP-203 · Question #52

Drag and Drop Question You need to create an Azure Data Factory pipeline to process data for the following three departments at your company: Ecommerce, retail, and wholesale. The solution must ensure

The correct answer is dept=='ecommerce', dept=='retail', dept=='wholesale'; ecommerce, retail, wholesale, all. In Azure Data Factory data flow, the conditional split transformation uses filter expressions like dept=='ecommerce', dept=='retail', dept=='wholesale' to route rows to named output streams. The output stream names must then be declared as 'ecommerce, retail, wholesale, all' - wh

Submitted by takeshi77· Mar 30, 2026Design and Implement Data Storage and Processing Pipelines in Azure (DP-203 / Azure Data Engineer Associate)

Question

Drag and Drop Question You need to create an Azure Data Factory pipeline to process data for the following three departments at your company: Ecommerce, retail, and wholesale. The solution must ensure that data can also be processed for the entire company. How should you complete the Data Factory data flow script? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Exhibit

DP-203 question #52 exhibit

Answer Area

Drag items

all, ecommerce, retail, wholesaledept=='ecommerce', dept=='retail', dept=='wholesale'dept=='ecommerce', dept=='retail', 'wholesale', dept=='retail'disjoint: falsedisjoint: trueecommerce, retail, wholesale, all

Correct arrangement

  • dept=='ecommerce', dept=='retail', dept=='wholesale'
  • ecommerce, retail, wholesale, all

Explanation

In Azure Data Factory data flow, the conditional split transformation uses filter expressions like dept=='ecommerce', dept=='retail', dept=='wholesale' to route rows to named output streams. The output stream names must then be declared as 'ecommerce, retail, wholesale, all' - where 'all' is the default/catch-all stream that captures rows not matching any prior condition, ensuring company-wide data processing is also supported. The order matters: conditions are evaluated top-down, and the unmatched remainder flows to the final named stream ('all'), which serves as the disjoint-false default output.

Topics

#Azure Data Factory#Data Flow#Conditional Split Transformation#Pipeline Scripting

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice