DP-203 Develop data processing Practice Question
Which TWO of the following are built-in components of Azure Data Factory that can be used to perform data transformation without writing custom code?
⚠ Common exam trap
Test-takers frequently confuse the Copy Activity with a transformation tool because it can perform simple column mapping and data type conversions, but it lacks the ability to handle complex, multi-step transformations like those in Mapping Data Flows.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Mapping Data Flow
Mapping Data Flow (A) is a built-in Azure Data Factory component that allows you to design data transformations visually using a graphical interface, without writing any code. It executes at scale on Azure Databricks clusters and supports operations like joins, aggregations, and pivots, making it a code-free transformation tool.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Mapping Data Flow
Why this is correct
Mapping Data Flows allow visual data transformation without code.
- ✗
Copy Activity
Why it's wrong here
Copy Activity is for data movement, not transformation.
- ✓
Data Flow Script
Why this is correct
Data Flow Script is the code behind Mapping Data Flows and can be edited directly.
- ✗
Azure Function Activity
Why it's wrong here
Azure Function Activity calls external functions, not a built-in transformation component.
- ✗
Stored Procedure Activity
Why it's wrong here
Stored Procedure Activity runs T-SQL but is not a built-in transformation component.
Go deeper
Related to this question
Learn chapter
Introduction to Azure Data Engineering
Key term
Azure Data Factory
Azure Data Factory is a cloud-based data integration service that lets you create, schedule, and orchestrate data pipelines to move and transform data from various sources to destinations.
Key term
Azure Databricks
Azure Databricks is a fast, easy, and collaborative Apache Spark-based analytics platform optimized for Azure that lets data teams prepare data, run machine learning models, and build data pipelines using a single workspace.
About these practice questions
Courseiva writes every DP-203 question from scratch — 760 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-203 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-203 exam.