Azure Data Factory Mapping Data Flows
A company receives daily sales data from multiple retail stores as CSV files that are uploaded to Azure Blob Storage. The data must be cleansed, validated, and aggregated before being loaded into Azure Synapse Analytics for reporting. The transformations involve complex business logic and must run reliably every night. The company wants a service that can orchestrate and execute the entire pipeline with minimal development effort. Which Azure service should they use?
Quick Answer
The answer is Azure Data Factory with mapping data flows. This service is correct because mapping data flows provide a code-free, visual interface for building complex ETL transformations like cleansing, validation, and aggregation, executing them at scale on serverless Azure Databricks clusters without requiring any manual Spark code. On the Microsoft Azure Data Fundamentals DP-900 exam, this question tests your understanding of which Azure service handles orchestrated, code-free data transformation pipelines for batch workloads—a common scenario where candidates might mistakenly choose Azure Databricks (which requires coding) or Azure Synapse Pipelines (which lacks the dedicated visual transformation designer). The key trap is confusing orchestration with transformation: Data Factory orchestrates the entire pipeline, while mapping data flows handle the actual data shaping. Remember the mnemonic “Map it, don’t code it” to recall that mapping data flows are the no-code transformation engine within Data Factory’s scheduling framework.
⚠ Common exam trap
Many candidates confuse Azure Data Factory with Azure Logic Apps because both are 'orchestration' services, but Logic Apps is for API/application integration (HTTP, Office 365, etc.) and cannot perform large-scale data transformations or run Spark-based 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
✓
Azure Data Factory with mapping data flows
Azure Data Factory with mapping data flows is correct because it provides a code-free, visual interface for building complex data transformations (cleansing, validation, aggregation) that can be orchestrated on a schedule. Mapping data flows execute at scale on Azure Databricks clusters without requiring manual Spark code, making it ideal for nightly batch ETL pipelines with minimal development effort.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Azure Data Factory with mapping data flows
Why this is correct
Azure Data Factory provides schedule-based orchestration and mapping data flows to perform complex transformations without coding. It integrates seamlessly with Azure Synapse Analytics for loading transformed data.
- ✗
Azure Stream Analytics
Why it's wrong here
Azure Stream Analytics is designed for real-time stream processing, not for scheduled batch transformations of files. It is not suitable for this nightly batch workload.
When this WOULD be correct
A company needs to process a continuous stream of sales data from IoT devices, performing real-time aggregations and alerting when sales exceed thresholds, then output results to Azure Synapse Analytics for live dashboards.
- ✗
Azure Databricks
Why it's wrong here
Azure Databricks can transform data using notebooks, but it lacks built-in orchestration for scheduling and monitoring pipelines. Additional setup is needed, making it less efficient than Azure Data Factory for this requirement.
When this WOULD be correct
A company needs to perform advanced analytics and machine learning on large datasets using custom Python or Scala code, with the ability to scale compute resources dynamically. The question would specify that data scientists need to collaborate on complex transformations and model training, making Databricks the right choice.
- ✗
Azure Logic Apps
Why it's wrong here
Azure Logic Apps is for workflow automation and integration, not for heavy data transformations and large-scale ETL. It is not designed to handle complex data cleansing and aggregation operations.
When this WOULD be correct
A company needs to automate a workflow that triggers when a new CSV file is uploaded to Blob Storage, then sends an email notification and copies the file to another container. Minimal coding and quick integration with Office 365 are required.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.
✓Azure Data Factory with mapping data flowsCorrect answer▾
Why this is correct
Azure Data Factory provides schedule-based orchestration and mapping data flows to perform complex transformations without coding. It integrates seamlessly with Azure Synapse Analytics for loading transformed data.
✗Azure Stream AnalyticsWrong answer — click to see why▾
Why this is wrong here
Azure Stream Analytics is designed for real-time stream processing, not for scheduled batch orchestration of complex transformations on daily CSV files. It lacks native scheduling and orchestration capabilities for nightly batch pipelines.
★ When this WOULD be the correct answer
A company needs to process a continuous stream of sales data from IoT devices, performing real-time aggregations and alerting when sales exceed thresholds, then output results to Azure Synapse Analytics for live dashboards.
Why candidates choose this
Candidates may confuse batch processing with stream processing, or think that 'data flows' implies streaming, leading them to select Stream Analytics for any data transformation task.
✗Azure DatabricksWrong answer — click to see why▾
Why this is wrong here
Azure Databricks is a powerful analytics platform but requires significant development effort to write and maintain Spark code for complex transformations, whereas the question emphasizes minimal development effort and orchestration. Data Factory with mapping data flows provides a code-free, managed orchestration and transformation service better suited for this nightly batch pipeline.
★ When this WOULD be the correct answer
A company needs to perform advanced analytics and machine learning on large datasets using custom Python or Scala code, with the ability to scale compute resources dynamically. The question would specify that data scientists need to collaborate on complex transformations and model training, making Databricks the right choice.
Why candidates choose this
Candidates may associate Databricks with complex data transformations and batch processing, overlooking that it requires more development effort and is not primarily an orchestration service like Data Factory.
✗Azure Logic AppsWrong answer — click to see why▾
Why this is wrong here
Azure Logic Apps is designed for lightweight, event-driven workflows and integrations, not for orchestrating complex ETL pipelines with data cleansing, validation, and aggregation on large datasets. It lacks native data flow capabilities and is not optimized for scheduled, high-volume data processing.
★ When this WOULD be the correct answer
A company needs to automate a workflow that triggers when a new CSV file is uploaded to Blob Storage, then sends an email notification and copies the file to another container. Minimal coding and quick integration with Office 365 are required.
Why candidates choose this
Candidates may confuse Logic Apps' workflow orchestration with Data Factory's ETL orchestration, assuming both can handle data pipelines. Logic Apps is simpler to set up for basic tasks, leading to the misconception that it can scale to complex data transformations.
Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Quick reference
Azure Blob Storage Tier Comparison
| Tier | Storage Cost | Retrieval Cost | Latency | Use Case |
|---|---|---|---|---|
| Hot | Highest | Lowest | Immediate | Active data, frequent reads |
| Cool | Lower | Higher | Immediate | Data accessed < once / month |
| Cold | Lower still | Higher | Immediate | Data accessed < once / quarter |
| Archive | Lowest | Highest + rehydration delay | Hours | Long-term compliance retention |
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
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-900 question from scratch — 820 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 →
Same concept, more angles
1 more way this is tested on DP-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company needs to ingest data from an on-premises SQL Server database into Azure SQL Database every hour. During the ingestion, they need to filter out rows where Status = 'Inactive' and convert a date column to a different format. They want a cloud-based, code-free solution that can schedule and orchestrate this task. Which Azure service should they use?
medium- A.Azure Logic Apps
- ✓ B.Azure Data Factory with Mapping Data Flows
- C.Azure Functions
- D.Azure SQL Database Change Data Capture
Why B: Azure Data Factory with Mapping Data Flows is the correct choice because it provides a cloud-based, code-free ETL service that can ingest data from on-premises SQL Server into Azure SQL Database, apply transformations like filtering rows (Status = 'Inactive') and converting date formats, and schedule the task using triggers. Mapping Data Flows run on Spark clusters and allow visual data transformation without writing code, making it ideal for this orchestrated, scheduled ingestion.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 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-900 exam.