Question 186 of 981
AZ-900 Describe Azure architecture and services Practice Question
Which Azure service provides a visual designer for building data transformation and movement pipelines between data stores?
⚠ Common exam trap
Test-takers frequently confuse Azure Data Factory with Azure Synapse Analytics Studio because both offer visual design surfaces, but Synapse Studio is for querying and managing analytics workloads within a Synapse workspace, not for building generic data movement pipelines between diverse data stores.
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
Azure Data Factory (ADF) is the correct answer because it is a cloud-based ETL and data integration service that provides a visual designer (the ADF authoring canvas) for building data transformation and movement pipelines. These pipelines can copy data between over 90 supported on-premises and cloud data stores, and they can include transformations using mapping data flows or external compute services like Azure HDInsight and Azure Databricks.
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 Synapse Analytics Studio
Why it's wrong here
Azure Synapse Analytics Studio is a unified analytics workspace for data warehousing and big data analytics, offering SQL pools, Spark pools, and serverless query capabilities. Although it integrates an embedded pipeline interface that is actually powered by Azure Data Factory, its primary purpose is not standalone ETL orchestration. The dedicated cloud service that provides a visual ETL pipeline designer for data movement and transformation is Azure Data Factory.
- ✓
Azure Data Factory
Why this is correct
Azure Data Factory is Microsoft's hybrid data integration service that provides a code-free, visual pipeline designer for building ETL and ELT workflows. It supports over 90 built-in connectors to on-premises, SaaS, and cloud data stores, and includes Mapping Data Flows to transform data without writing code. You can schedule pipelines or trigger them on events, making it the dedicated service for visual ETL pipeline design.
- ✗
Azure Databricks
Why it's wrong here
Azure Databricks is a Spark-based analytics platform that lets data engineers and data scientists author transformations using code in notebooks—typically Python, Scala, or SQL. It provides powerful distributed processing for ETL tasks, but its development model is code-first rather than a drag-and-drop visual pipeline designer. Azure Data Factory, by contrast, offers the no-code visual interface for building data pipelines, which is why it is the correct answer.
- ✗
Azure Stream Analytics
Why it's wrong here
Azure Stream Analytics is a real-time event-processing engine that applies SQL-like queries continuously to streaming data from sources such as Event Hubs, IoT Hub, or Blob storage. It is optimized for low-latency, unbounded data streams and provides windowing, alerts, and reference data joins, but it does not offer a visual pipeline designer for batch ETL or data integration. Since the requirement is a visual ETL pipeline designer, Data Factory is the correct service.
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 →
Last reviewed: Jun 11, 2026
This AZ-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 AZ-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.