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.
DP-900 Describe an analytics workload on Azure Practice Question
This DP-900 practice question tests your understanding of describe an analytics workload on azure. This is a configuration task: choose the command set that satisfies every stated requirement. Small differences — like 'secret' vs 'password' or 'transport input ssh' vs 'all' — change whether the answer is correct. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
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?
Clue words in this question
Noticing these words before you look at the options changes how you read each choice.
Clue: "primary"
Why it matters: Asks for the main purpose or function, not a secondary benefit. Eliminate answers that describe side-effects or partial functions.
Clue: "minimum / minimize"
Why it matters: Asks for the least resource use — fewest addresses, smallest subnet, lowest overhead. Eliminate over-provisioned options even if they would technically work.
Correct. ADF Data Flows allow visual, code-free transformations with conditional logic, and ADF handles orchestration.
B
Azure Databricks with notebooks
Why wrong: Incorrect. Databricks requires writing code (Python, Scala, SQL) and is not a visual, configuration-based approach.
C
Azure Stream Analytics
Why wrong: Incorrect. Stream Analytics is designed for real-time streaming data, not batch ingestion and complex conditional transformations with branching.
D
Azure Logic Apps
Why wrong: Incorrect. Logic Apps is for workflow automation and integration, not for heavy data transformation and loading into a data warehouse.
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.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
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.
Clue confirmation
The clue words "primary", "minimum / minimize" in the question point toward this answer.
Related concept
Read the scenario before looking for a memorised answer.
✗
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.
✗
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.
✗
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.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates may 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.
Detailed technical explanation
How to think about this question
Azure Data Factory Mapping Data Flows execute transformations on Azure Databricks clusters under the hood, but the user interacts via a visual canvas with activities like Conditional Split (for branching) and Derived Column (for logic). The service uses a 'code-free' expression language for complex logic, and data is processed in a Spark-based environment, enabling scalable, distributed transformations without manual cluster management.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
Related glossary terms
Concepts from this question explained
These glossary pages explain the core terms tested in this DP-900 question in full detail.
Describe an analytics workload on Azure — This question tests Describe an analytics workload on Azure — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: 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.
What should I do if I get this DP-900 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Are there clue words in this question I should notice?
Yes — watch for: "primary", "minimum / minimize". Asks for the main purpose or function, not a secondary benefit. Eliminate answers that describe side-effects or partial functions.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
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.
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.