AZ-900 Describe Azure architecture and services Practice Question
Which Azure service provides a fully managed platform for building real-time analytics and complex event processing using SQL-like queries on streaming data?
⚠ Common exam trap
Many exam-takers confuse Azure Stream Analytics with Azure Synapse Analytics, mistakenly thinking Synapse's SQL pools can handle real-time streaming, when in fact Synapse is optimized for stored data analytics and requires a separate streaming service like Stream Analytics for real-time ingestion.
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 Stream Analytics
Azure Stream Analytics is a fully managed platform-as-a-service (PaaS) that enables real-time analytics and complex event processing (CEP) on streaming data using a SQL-like query language. It ingests data from sources like Azure Event Hubs or IoT Hub, applies temporal windows and pattern matching, and outputs results to sinks such as Azure SQL Database or Power BI, all without requiring infrastructure management.
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 HDInsight
Why it's wrong here
Azure HDInsight is a managed service that deploys open-source big data frameworks such as Apache Hadoop, Spark, and Hive onto clusters, primarily suited for batch processing and large-scale data transformation. While Spark does include Structured Streaming for near-real-time micro-batch processing, HDInsight requires you to manage the cluster infrastructure and does not provide a dedicated, serverless, always-on stream processing service like Stream Analytics, making it heavier and less immediate for pure real-time event processing.
- ✗
Azure Synapse Analytics
Why it's wrong here
Azure Synapse Analytics is an enterprise data warehousing and integrated analytics solution that combines big data and SQL querying in a unified workspace, focused on storing and querying large volumes of structured and semi-structured data. It is not a real-time streaming service; it typically ingests data via pipelines (including from Stream Analytics) and serves as a storage/analysis layer, rather than processing live events continuously with sub-second latency for event-by-event analytics.
- ✓
Azure Stream Analytics
Why this is correct
Azure Stream Analytics is a fully managed, real-time stream processing engine that ingests data from sources like Azure Event Hubs, IoT Hub, or Blob storage, and then runs continuous, SQL-like queries to detect patterns, aggregate metrics, or trigger alerts. It delivers sub-second-to-second latency analytics without requiring custom code for event handling, making it the optimal choice for real-time telemetry, sensor data, or financial transaction monitoring.
- ✗
Azure Data Factory
Why it's wrong here
Azure Data Factory is a cloud-based ETL (extract, transform, load) and data integration service designed primarily for batch data movement and orchestration. While it can invoke real-time endpoints or schedule pipelines, it does not natively process high-velocity streaming events with low-latency continuous queries; its strength lies in moving and transforming data on a scheduled or trigger-based cadence, not in sub-second stream analytics.
Go deeper
Related to this question
Learn chapter
Azure Regions and Geographies
Key term
Azure Stream Analytics
Azure Stream Analytics is a fully managed, real-time data processing service that analyzes and transforms high volumes of streaming data from various sources to deliver low-latency insights and trigger actions.
Key term
PaaS
Platform as a Service (PaaS) is a cloud computing model that provides a managed platform for developers to build, run, and manage applications without dealing with the underlying infrastructure.
About these practice questions
This AZ-900 question is part of Courseiva's 981-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 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.