DP-900 Describe an analytics workload on Azure Practice Question
A manufacturing company uses IoT sensors to collect temperature and vibration data from machinery. They need to analyze the streaming data in real time to detect anomalies and trigger alerts. Additionally, they need to run complex historical queries on months of sensor data to identify equipment failure patterns. They want a single Azure service that can handle both real-time stream processing and large-scale batch analytics using a unified query language, minimizing the need for separate technologies. Which Azure service should they use?
⚠ Common exam trap
Test-takers frequently confuse Azure Stream Analytics as a one-stop solution for both streaming and batch, overlooking its lack of native batch analytics capabilities, while Azure Synapse Analytics is designed specifically to unify these workloads.
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 Synapse Analytics
Azure Synapse Analytics is the correct choice because it provides a unified platform that combines both real-time stream processing (via Synapse Pipelines and Spark Streaming) and large-scale batch analytics (via Synapse SQL and Spark) using a single query language (T-SQL or Spark SQL). This eliminates the need for separate technologies, directly addressing the requirement for a single service to handle both streaming and historical batch analysis.
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 real-time event processing engine but does not support complex batch queries on historical data. It would need to be combined with another service for batch analytics, which contradicts the requirement for a single service.
When this WOULD be correct
A question that asks for a service to perform real-time analytics on streaming data (e.g., from IoT devices) and output results to a dashboard or alert system, without requiring batch analytics or a unified query language for both stream and batch.
- ✗
Azure Data Lake Storage Gen2
Why it's wrong here
Azure Data Lake Storage Gen2 is a storage service, not a compute service. It provides a scalable data lake but requires separate compute (e.g., Azure Synapse or Azure Databricks) to perform analytics, so it does not meet the 'single service' requirement.
When this WOULD be correct
A company needs a scalable, cost-effective data lake for storing petabytes of structured and unstructured data from various sources, with hierarchical namespace support for fine-grained access control, and plans to use separate analytics services like Azure Synapse or Databricks for processing.
- ✓
Azure Synapse Analytics
Why this is correct
Azure Synapse Analytics is a unified analytics platform that supports both real-time stream processing (via pipelines and Spark streaming) and batch analytics with T-SQL and Apache Spark, all within a single service. It provides a unified query language and minimizes architecture complexity.
- ✗
Azure HDInsight
Why it's wrong here
Azure HDInsight is a managed big data platform that supports various open-source frameworks like Hadoop, Spark, and Kafka. While it can handle both batch and streaming, it does not provide a single unified query language; it often requires using multiple components (e.g., Spark for streaming, Hive for batch) and more management effort.
When this WOULD be correct
A company needs to process large-scale batch and interactive queries on historical data using open-source frameworks like Hadoop, Spark, or Hive, and is willing to manage separate clusters for streaming and batch. They prioritize flexibility and custom cluster configurations over a unified query language.
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 Synapse AnalyticsCorrect answer▾
Why this is correct
Azure Synapse Analytics is a unified analytics platform that supports both real-time stream processing (via pipelines and Spark streaming) and batch analytics with T-SQL and Apache Spark, all within a single service. It provides a unified query language and minimizes architecture complexity.
✗Azure Stream AnalyticsWrong answer — click to see why▾
Why this is wrong here
Azure Stream Analytics is designed for real-time stream processing but lacks native support for complex historical batch queries and a unified query language for both streaming and batch analytics, requiring separate technologies for batch processing.
★ When this WOULD be the correct answer
A question that asks for a service to perform real-time analytics on streaming data (e.g., from IoT devices) and output results to a dashboard or alert system, without requiring batch analytics or a unified query language for both stream and batch.
Why candidates choose this
Candidates may choose Stream Analytics because it is a well-known Azure service for real-time stream processing, and they might overlook the requirement for unified batch and streaming analytics, assuming Stream Analytics can handle both.
✗Azure Data Lake Storage Gen2Wrong answer — click to see why▾
Why this is wrong here
Azure Data Lake Storage Gen2 is a storage service, not a real-time stream processing or batch analytics engine. It cannot analyze streaming data or run complex queries directly; it only stores data for later processing by other services.
★ When this WOULD be the correct answer
A company needs a scalable, cost-effective data lake for storing petabytes of structured and unstructured data from various sources, with hierarchical namespace support for fine-grained access control, and plans to use separate analytics services like Azure Synapse or Databricks for processing.
Why candidates choose this
Candidates may confuse Data Lake Storage with analytics services because it is often used in big data architectures, and the term 'analytics' in the question might lead them to think storage is sufficient for analysis.
✗Azure HDInsightWrong answer — click to see why▾
Why this is wrong here
Azure HDInsight requires separate cluster configurations for real-time (e.g., Spark Streaming) and batch (e.g., Spark SQL) processing, and does not offer a unified query language across both paradigms. The question emphasizes a single service with a unified query language, which HDInsight does not provide out-of-the-box.
★ When this WOULD be the correct answer
A company needs to process large-scale batch and interactive queries on historical data using open-source frameworks like Hadoop, Spark, or Hive, and is willing to manage separate clusters for streaming and batch. They prioritize flexibility and custom cluster configurations over a unified query language.
Why candidates choose this
Candidates may associate HDInsight with big data analytics and streaming via Spark Streaming, overlooking that it lacks a single unified query language and requires separate cluster setups for real-time and batch workloads.
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
Stream processing
Stream processing is a data processing method that continuously analyzes and acts on data in real time as it arrives, rather than storing it first and processing it later.
Key term
Azure Synapse Analytics
Azure Synapse Analytics is a cloud-based data integration, warehousing, and analytics service that brings together big data and data warehouse capabilities under one platform.
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.