DP-900 Describe an analytics workload on Azure Practice Question
A retail company needs to analyze clickstream data from their website in real time to detect fraudulent activity and also run complex historical queries on months of data to identify shopping trends. They want a single service that can handle both streaming and batch analytics using a unified query language, minimizing data movement. Which Azure service should they use?
⚠ Common exam trap
A common mix-up: candidates choose Azure Stream Analytics because it is explicitly marketed for real-time streaming, but they overlook the requirement for complex historical queries and a unified query language, which ADX uniquely satisfies with KQL.
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 Explorer
Azure Data Explorer (ADX) is designed for real-time analytics on streaming data and can also handle complex historical queries over large volumes of data using the Kusto Query Language (KQL). It minimizes data movement by ingesting streaming data directly and storing it in a columnar format optimized for both real-time and batch queries, making it the ideal single service 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 Stream Analytics
Why it's wrong here
Azure Stream Analytics is a fully managed real-time stream processing engine that runs continuous SQL-like queries against data in motion, performing transformations, aggregations, and anomaly detection on the fly. However, it holds no persistent storage for months of clickstream history—results must be written to a separate sink like Azure Data Lake or SQL Database—and its query engine is not designed for interactive, exploratory queries over large historical datasets, so it fails the combined workload's requirement for both real-time and ad-hoc historical analysis.
When this WOULD be correct
A question that asks for a service to process real-time streaming data from IoT devices or clickstreams and output results to a dashboard or alerting system, without requiring complex historical analytics on large datasets, would make Azure Stream Analytics the correct answer.
- ✗
Azure Synapse Analytics
Why it's wrong here
Azure Synapse Analytics is a unified data warehousing and big data analytics platform, but its core strengths are batch ETL, SQL-based relational warehousing, and BI workloads on structured data that has already been modeled. While it can ingest streaming data through pipelines, it does not provide native low-latency real-time analytics on raw clickstream events; instead, data must be staged and schema-managed before querying, and its interactive engine is optimized for large relational scans, not high-velocity log-style exploration, making it a poor fit for this specific real-time plus historical clickstream analysis.
When this WOULD be correct
A company needs to run complex T-SQL queries across petabytes of structured and unstructured data from multiple sources (e.g., CRM, ERP) for business intelligence and reporting, with minimal latency for interactive queries. They require a unified analytics platform that integrates with Power BI and Azure Machine Learning.
- ✗
Azure HDInsight
Why it's wrong here
Azure HDInsight is a managed cluster service for open-source frameworks like Apache Hadoop, Spark, Storm, and HBase, which requires you to select, deploy, and tune the appropriate cluster type for streaming or batch workloads. It does not offer a single unified query language optimized for both instantaneous streaming queries and years of interactive ad-hoc analysis—you must combine multiple components (e.g., Storm for streaming, Hive/Spark SQL for historical) and manage cluster scaling, making it operationally heavy and lacking the built-in low-latency query engine needed for clickstream data exploration.
When this WOULD be correct
A company needs to run custom MapReduce jobs or use open-source frameworks like Hadoop, Spark, or Hive on managed clusters, and does not require a single unified query language for both streaming and batch analytics.
- ✓
Azure Data Explorer
Why this is correct
Azure Data Explorer is purpose-built for real-time analytics on high-velocity clickstream data, ingesting streams with sub-second latency while storing data in a compressed columnar format for months. Its Kusto Query Language (KQL) enables interactive, ad-hoc queries against both newly arriving events and historical aggregates in the same workspace, making it the only option that natively unifies streaming ingestion and deep historical exploration without needing a separate data store or compute engine.
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 ExplorerCorrect answer▾
Why this is correct
Azure Data Explorer is purpose-built for real-time analytics on high-velocity clickstream data, ingesting streams with sub-second latency while storing data in a compressed columnar format for months. Its Kusto Query Language (KQL) enables interactive, ad-hoc queries against both newly arriving events and historical aggregates in the same workspace, making it the only option that natively unifies streaming ingestion and deep historical exploration without needing a separate data store or compute engine.
✗Azure Stream AnalyticsWrong answer — click to see why▾
Why this is wrong here
Azure Stream Analytics is optimized for real-time stream processing but lacks native support for complex historical queries on months of data using a unified query language. It would require combining with another service for batch analytics, increasing data movement.
★ When this WOULD be the correct answer
A question that asks for a service to process real-time streaming data from IoT devices or clickstreams and output results to a dashboard or alerting system, without requiring complex historical analytics on large datasets, would make Azure Stream Analytics the correct answer.
Why candidates choose this
Candidates may think Stream Analytics can handle both streaming and batch because it supports windowed aggregations, but they overlook its limitations for ad-hoc historical queries and the need for a separate storage/query service for batch analytics.
✗Azure Synapse AnalyticsWrong answer — click to see why▾
Why this is wrong here
Azure Synapse Analytics is optimized for large-scale data warehousing and T-SQL based analytics, but it does not natively support real-time streaming analytics with a unified query language for both streaming and batch. It requires separate services (e.g., Stream Analytics) for real-time ingestion, increasing data movement.
★ When this WOULD be the correct answer
A company needs to run complex T-SQL queries across petabytes of structured and unstructured data from multiple sources (e.g., CRM, ERP) for business intelligence and reporting, with minimal latency for interactive queries. They require a unified analytics platform that integrates with Power BI and Azure Machine Learning.
Why candidates choose this
Candidates may confuse Azure Synapse Analytics as a 'unified' analytics service that can handle both streaming and batch, but its strength is in large-scale data warehousing and T-SQL analytics, not real-time stream processing.
✗Azure HDInsightWrong answer — click to see why▾
Why this is wrong here
Azure HDInsight requires separate clusters for streaming (e.g., Spark Streaming) and batch (e.g., Hive) and does not offer a unified query language across both modes, leading to data movement and complexity.
★ When this WOULD be the correct answer
A company needs to run custom MapReduce jobs or use open-source frameworks like Hadoop, Spark, or Hive on managed clusters, and does not require a single unified query language for both streaming and batch analytics.
Why candidates choose this
Candidates may associate HDInsight with big data analytics and assume it can handle both streaming and batch, overlooking that it lacks a unified query language and requires separate processing engines.
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
Service
A service is a software component or system that performs a specific function and is available to be used by other programs or users over a network.
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
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 →
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.