AZ-204 Practice Question: Connect to and consume Azure services and third-party services
An application uses Azure Event Hubs to ingest telemetry data. The team wants to process the data in near real-time and store aggregated results in Azure SQL Database. Which Azure service should they use?
⚠ Common exam trap
Test-takers frequently confuse Azure Functions as a real-time stream processor, but it lacks native windowed aggregation and state management, making Stream Analytics the correct choice for this specific near-real-time aggregation requirement.
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 the correct choice because it is a fully managed stream processing engine designed for real-time analytics on high-throughput data from sources like Event Hubs. It can ingest telemetry data, apply SQL-based queries for aggregation (e.g., tumbling windows), and output results directly to Azure SQL Database with exactly-once semantics, meeting the near-real-time requirement.
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 for open-source analytics frameworks like Hadoop, Spark, and Kafka, primarily designed for batch processing or complex near real-time analytics on large datasets. While Spark on HDInsight can perform streaming, it involves significant operational overhead and is not the most efficient or cost-effective solution for straightforward, continuous real-time telemetry processing from Event Hubs compared to dedicated stream processing services. Its strength lies in big data batch analytics rather than low-latency stream transformations.
- ✗
Azure Functions
Why it's wrong here
Azure Functions can process events from Event Hubs using custom code, offering flexibility for specific logic. However, for complex real-time stream processing scenarios involving aggregations, windowing functions, or joining multiple data streams, implementing and maintaining this logic in custom code can become intricate and resource-intensive. Azure Stream Analytics provides a declarative, SQL-like language specifically optimized for these common streaming patterns, significantly reducing development effort and improving the maintainability of stream analytics solutions.
- ✓
Azure Stream Analytics
Why this is correct
Azure Stream Analytics is a fully managed, real-time analytics service specifically designed for processing large volumes of streaming data from sources like Azure Event Hubs. It enables users to define complex event processing (CEP) queries using a SQL-like language to filter, aggregate, and transform data in motion, often incorporating windowing functions for time-based analysis. This service is ideal for scenarios requiring low-latency insights from telemetry, allowing direct output to various sinks, including Azure SQL Database, for immediate consumption or further analysis.
- ✗
Azure Data Lake Storage Gen2
Why it's wrong here
Azure Data Lake Storage Gen2 is a highly scalable and secure storage solution built on Azure Blob Storage, optimized for big data analytics workloads. It provides hierarchical namespaces and is designed for storing vast amounts of data, including raw telemetry, for subsequent batch processing or archival purposes. While it can serve as a destination for processed stream data, it does not inherently perform real-time stream processing or transformation of data directly from Event Hubs. Its primary role is data persistence and serving as a data lake, not active data manipulation in transit.
Go deeper
Related to this question
About these practice questions
Courseiva writes every AZ-204 question from scratch — 881 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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-204 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-204 exam.