Which Azure Service Provides Visual ETL Pipelines for Synapse?
A financial services company needs to build a data pipeline that ingests daily transaction files from multiple sources. The pipeline must perform data quality checks, transform data using complex business logic, and load it into Azure Synapse Analytics. The transformations involve conditional branching (e.g., if a transaction amount exceeds a threshold, apply additional validation). The company wants to minimize coding effort and prefers a visual, configuration-based approach. Which Azure service should they use as the primary orchestration and transformation engine?
Quick Answer
The answer is Azure Data Factory with Data Flows. This service is the correct choice because it offers a visual, configuration-based interface for building ETL pipelines that handle both orchestration and complex transformations, including conditional branching through transformations like conditional split—perfect for applying additional validation when a transaction amount exceeds a threshold. On the Microsoft Azure Data Fundamentals DP-900 exam, this question tests your understanding of when to choose a visual ETL tool over code-heavy alternatives like Azure Databricks or T-SQL scripts; a common trap is selecting Azure Synapse Pipelines alone, which lacks the native visual data transformation capabilities of Data Flows. To remember, think of Data Factory as the “orchestrator” and Data Flows as the “visual transformer” working together to build a visual ETL pipeline to Azure Synapse without writing code.
⚠ Common exam trap
Many candidates confuse Azure Data Factory with Azure Databricks, assuming Databricks is required for complex transformations, but Data Flows provide the same Spark power with a visual interface, meeting the 'minimize coding' requirement.
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 Data Flows
Azure Data Factory with Data Flows is the correct choice because it provides a visual, configuration-based interface for both orchestration and transformation, including support for complex business logic like conditional branching (e.g., via conditional split transformations). It natively integrates with Azure Synapse Analytics for loading transformed data, minimizing coding effort compared to code-heavy alternatives.
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 Data Flows
Why this is correct
Correct. ADF Data Flows allow visual, code-free transformations with conditional logic, and ADF handles orchestration.
- ✗
Azure Databricks with notebooks
Why it's wrong here
Incorrect. Databricks requires writing code (Python, Scala, SQL) and is not a visual, configuration-based approach.
When this WOULD be correct
A data science team needs to build a machine learning pipeline that ingests streaming data, performs advanced analytics (e.g., anomaly detection using custom algorithms), and requires collaborative development with version control. Azure Databricks with notebooks would be the correct choice for its support for ML frameworks and collaborative coding.
- ✗
Azure Stream Analytics
Why it's wrong here
Incorrect. Stream Analytics is designed for real-time streaming data, not batch ingestion and complex conditional transformations with branching.
When this WOULD be correct
A company needs to process real-time sensor data from IoT devices, apply windowed aggregations, and output alerts to Azure Event Hubs. They prefer a serverless, SQL-based approach without managing infrastructure. Azure Stream Analytics would be the correct choice.
- ✗
Azure Logic Apps
Why it's wrong here
Incorrect. Logic Apps is for workflow automation and integration, not for heavy data transformation and loading into a data warehouse.
When this WOULD be correct
A company needs to automate a business process that triggers when a new file is uploaded to Blob Storage, then sends an email notification and updates a CRM record. The question emphasizes low-code integration between SaaS services and minimal data transformation.
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 Data FlowsCorrect answer▾
Why this is correct
Correct. ADF Data Flows allow visual, code-free transformations with conditional logic, and ADF handles orchestration.
✗Azure Databricks with notebooksWrong answer — click to see why▾
Why this is wrong here
Azure Databricks with notebooks requires coding in Python, Scala, or SQL, not a visual, configuration-based approach. The question explicitly prefers minimal coding effort and a visual approach, making Databricks unsuitable.
★ When this WOULD be the correct answer
A data science team needs to build a machine learning pipeline that ingests streaming data, performs advanced analytics (e.g., anomaly detection using custom algorithms), and requires collaborative development with version control. Azure Databricks with notebooks would be the correct choice for its support for ML frameworks and collaborative coding.
Why candidates choose this
Candidates may associate Databricks with data transformation and orchestration, overlooking the requirement for a visual, low-code solution. They might also overestimate the ease of use of notebooks for non-coders.
✗Azure Stream AnalyticsWrong answer — click to see why▾
Why this is wrong here
Azure Stream Analytics is designed for real-time stream processing, not batch ingestion and transformation of daily transaction files. It lacks the visual, configuration-based data flow capabilities for complex business logic with conditional branching required by the question.
★ When this WOULD be the correct answer
A company needs to process real-time sensor data from IoT devices, apply windowed aggregations, and output alerts to Azure Event Hubs. They prefer a serverless, SQL-based approach without managing infrastructure. Azure Stream Analytics would be the correct choice.
Why candidates choose this
Candidates might confuse Stream Analytics' ability to handle transformations with the batch-oriented, visual data flows of Data Factory, especially if they overlook the 'daily files' batch requirement and focus on the 'transformation' aspect.
✗Azure Logic AppsWrong answer — click to see why▾
Why this is wrong here
Azure Logic Apps is designed for lightweight workflow automation and integration, not for complex data transformations with conditional branching on large datasets. It lacks native data flow capabilities and is not optimized for orchestrating ETL pipelines into Azure Synapse Analytics.
★ When this WOULD be the correct answer
A company needs to automate a business process that triggers when a new file is uploaded to Blob Storage, then sends an email notification and updates a CRM record. The question emphasizes low-code integration between SaaS services and minimal data transformation.
Why candidates choose this
Candidates may confuse Logic Apps' visual designer and low-code approach with Data Factory's visual ETL capabilities, overlooking that Logic Apps is for integration workflows, not heavy data transformation and orchestration.
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?”
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Azure Synapse Analytics
Azure Synapse Analytics is a cloud-based data integration, warehousing, and analytics service that brings together big data and data warehouse capabilities under one platform.
Key term
Pipeline
A pipeline is an automated series of steps that takes code from development to production, ensuring quality and speed.
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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 data engineering team is building a data pipeline to run daily batch loads from an on-premises SQL Server to Azure Synapse Analytics. The pipeline must include data transformation using a visual interface with no coding, and must support schema mapping and data validation. Which THREE Azure services should be used together?
medium- ✓ A.Azure Synapse Analytics
- ✓ B.Azure Data Factory
- C.Azure Databricks
- ✓ D.Azure Blob Storage
- E.Azure Analysis Services
Why A: Azure Synapse Analytics is the correct destination for the pipeline because it is a cloud-based data warehouse that supports high-performance analytics on large-scale data, making it ideal for daily batch loads from SQL Server. It integrates natively with Azure Data Factory for orchestration and Azure Blob Storage for staging, enabling schema mapping and data validation through visual interfaces without coding.
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.