AZ-900 Describe Azure architecture and services Practice Question
Which Azure service provides near real-time data analytics using SQL queries on streaming data from sources like IoT devices?
⚠ Common exam trap
Many candidates 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 batch and interactive analytics on stored data, not continuous streaming queries.
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, real-time analytics service designed to process high-velocity streaming data from sources like IoT devices, social media feeds, or application logs. It uses a SQL-like query language to perform near real-time analytics, aggregations, and pattern matching on data as it arrives, 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 platform for large-scale data warehousing and big data analytics, combining dedicated SQL pools, serverless SQL, and Apache Spark within a single workspace. It is designed to process large volumes of structured and semi-structured data using batch-oriented workloads, with distribution and partitioning to optimize queries over massive tables. Although Synapse can ingest streaming data through its pipelines, it does not perform continuous per-event query processing; it stores and analyzes data after it lands, so it cannot deliver real-time streaming analytics.
- ✓
Azure Stream Analytics
Why this is correct
Azure Stream Analytics is the cloud service built specifically for real-time stream processing, accepting data from sources like Event Hubs, IoT Hub, or Blob storage and applying SQL-based queries directly to the live data stream. It supports temporal constructs such as tumbling, hopping, and sliding windows to analyze patterns over time, then delivers results to Power BI, Cosmos DB, Azure Functions, or other destinations in near-real time. Its engine is optimized for sub-minute latency, enabling organizations to act on telemetry and high-velocity sensor events as they arrive.
- ✗
Azure Data Factory
Why it's wrong here
Azure Data Factory is a cloud-based ETL/ELT service that orchestrates and automates data movement and transformation across on-premises and cloud sources on schedules or event triggers. It primarily works with batched data through pipelines, copy activities, and external compute such as Databricks or SQL Server, not with unbounded real-time data streams. Data Factory can launch a pipeline after streaming data is persisted, but it cannot execute SQL-like queries directly on a continuous stream, making it unsuitable for real-time analytics.
- ✗
Azure Log Analytics
Why it's wrong here
Azure Log Analytics is a data-collection and querying tool within Azure Monitor, designed to analyze logs and metrics that have already been recorded. It stores historical telemetry in a log-analytics workspace and uses Kusto Query Language (KQL) for interactive investigation, not for continuously applying queries to live streaming data. While it can ingest data from event sources, it lacks the low-latency, event-by-event stream processing engine that Azure Stream Analytics provides.
Go deeper
Related to this question
Learn chapter
Azure Regions and Geographies
Key term
Query
A query is a request for information from a database, asking a specific question to retrieve, update, or manipulate data.
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.
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.