Question 146 of 981
AZ-900 Describe Azure architecture and services Practice Question
Which Azure service provides a fully managed, cloud-based data integration service for creating data-driven workflows?
⚠ Common exam trap
It's easy for candidates to confuse Azure Data Factory with Azure Synapse Analytics, as both involve data movement and transformation, but Synapse is primarily a unified analytics platform (data warehouse + big data), not a dedicated integration service for creating workflows.
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 a fully managed, cloud-based data integration service that allows you to create, schedule, and orchestrate data-driven workflows (pipelines). It supports over 90 built-in connectors to ingest, transform, and move data across on-premises and cloud sources, making it the correct choice for this scenario.
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
Why it's wrong here
Azure Synapse Analytics is an integrated analytics service that unifies data warehousing, big data analytics, and data integration into a single cloud platform. While it includes pipeline capabilities inherited from Azure Data Factory, its primary purpose is enabling query and analysis of data at scale, not serving as a standalone managed ETL service for creating data movement pipelines. The question specifically asks for a service whose focus is on moving and transforming data, which is the core identity of Azure Data Factory, not Synapse.
- ✓
Azure Data Factory
Why this is correct
Azure Data Factory is the correct answer because it is the managed cloud-based ETL service explicitly designed for creating data-driven pipelines that move and transform data. It enables you to define linked services, datasets, and activities to copy data from source to destination, and you can use control flow and data flows for transformation. This capability aligns directly with the question's description, making it the only option that fits.
- ✗
Azure Databricks
Why it's wrong here
Azure Databricks is an Apache Spark-based analytics platform designed for big data engineering and machine learning, not for orchestrating data movement pipelines. It provides interactive workspaces and clusters for processing and analyzing large datasets, whereas Azure Data Factory is the managed ETL service specifically built for creating, scheduling, and monitoring data integration pipelines. Therefore, its role does not match the description of a service for creating data-driven pipelines that move and transform data.
- ✗
Azure Stream Analytics
Why it's wrong here
Azure Stream Analytics is a real-time event-processing engine that runs continuous, declarative queries on streaming data from sources like IoT Hub or Event Hubs. It does not orchestrate batch ETL pipelines or manage scheduled data movement; instead, it reacts to data as it arrives. The question describes a service for creating data-driven pipelines to move and transform data, which is a batch-oriented ETL task that Stream Analytics does not perform.
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.