Match each Azure data tool to its purpose.
Drag a concept onto its matching description — or click a concept then click the description.
Data integration and orchestration
Apache Spark-based analytics platform
Real-time stream processing
Distributed analytics (legacy)
Managed open-source analytics service
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Azure Data Lake Storage: A scalable and secure data lake for high-performance analytics.
The correct matches are: Azure Data Lake Storage for scalable data lake storage, Azure Data Factory for data integration, and Azure Stream Analytics for real-time stream processing. Azure Synapse Analytics is a unified analytics platform, and Azure Databricks is an Apache Spark-based analytics platform. Common confusions include mixing up Synapse Analytics with Data Factory, and Databricks with Stream Analytics.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Azure Synapse Analytics: A cloud-based data integration service.
Why it's wrong here
Azure Synapse Analytics is a unified analytics platform that combines enterprise data warehousing with big data analytics, allowing users to query both relational and data lake data using serverless and dedicated SQL pools, as well as Apache Spark. It is not a cloud-based data integration service; that role belongs to Azure Data Factory. While Synapse includes pipeline capabilities inherited from Azure Data Factory, its core purpose is analytical processing, not data movement or ingestion orchestration.
Azure Data Lake Storage: A scalable and secure data lake for high-performance analytics.
Why this is correct
Azure Data Lake Storage (ADLS) is a highly scalable and secure data lake built on Azure Blob Storage, designed for high-performance analytics workloads. Its key differentiator is the hierarchical namespace, which enables directory-level permissions and efficient rename/move operations, and it can store petabytes of structured and unstructured data. Because it is storage rather than compute, it pairs naturally with analytics engines like Azure Synapse, Databricks, and HDInsight.
Azure Databricks: A real-time stream processing engine.
Why it's wrong here
Azure Databricks is an Apache Spark-based analytics platform that provides a collaborative workspace for data engineering, machine learning, and interactive big data analytics using shared compute clusters. Although it supports structured streaming for near-real-time micro-batch processing, it is not purpose-built as a real-time stream processing engine. Azure Stream Analytics is the service specifically designed for low-latency, event-stream processing using SQL-based queries.
Azure Data Factory: A cloud-based data integration service.
Why this is correct
Azure Data Factory (ADF) is a cloud-based ETL and data integration service that orchestrates data movement and transformation at scale. You use ADF to create data pipelines that ingest data from 90+ on-premises and cloud sources, transform it with data flows or external compute, and load it into destinations such as Azure Synapse or Azure Data Lake Storage. It is the correct answer for data integration, while analytics and storage are handled by other Azure services.
Azure Stream Analytics: A real-time stream processing engine.
Why this is correct
Azure Stream Analytics is a real-time stream processing engine that runs SQL-like queries on streaming data to produce low-latency insights. It integrates directly with sources like Azure Event Hubs and IoT Hub, and can write results to multiple sinks including Power BI, Azure Data Lake, and Azure Synapse. Unlike batch-oriented tools or storage services, it is optimized for continuous, time-windowed processing of events.
Go deeper
Learn chapter
Data Roles and Core Concepts
Key term
Data lake
A data lake is a centralized storage repository that holds vast amounts of raw data in its native format until it is needed for analysis.
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.
About these practice questions
This DP-900 question is part of Courseiva's 820-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
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.