Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureHard
A financial institution needs to analyze real-time market data to detect arbitrage opportunities. The data arrives continuously from multiple exchanges and must be processed with sub-second latency to identify patterns and trigger alerts. Which Azure service is specifically designed for real-time stream processing with low latency?
- AAzure Data Factory
- BAzure Stream Analytics
- CAzure Databricks
- DAzure Synapse Analytics dedicated SQL pool
Show answer & explanationAnswer & explanation
Correct answer: B. Azure Stream Analytics
Azure Stream Analytics is a fully managed, real-time analytics service designed for complex event processing over fast-moving streams of data. It enables you to quickly develop and deploy scalable solutions for real-time insights, with sub-second latency, making it ideal for scenarios like real-time fraud detection, IoT analytics, and market data analysis.
Why the other options are wrong
- A. Azure Data Factory is for orchestrating batch ETL/ELT pipelines, not real-time stream processing with sub-second latency.
- C. Azure Databricks can perform stream processing with Structured Streaming, but Stream Analytics is often simpler and more cost-effective for pure real-time event processing with SQL-like queries.
- D. Azure Synapse Analytics dedicated SQL pool is a data warehousing solution for structured data at rest, not for real-time stream analytics.
Azure Stream Analytics (ASA)
A real-time analytics service for complex event processing over fast-moving streams of data, offering low-latency insights.
- Fully managed stream processing engine.
- Uses SQL-like query language (Stream Analytics Query Language).
- Ideal for real-time dashboards, alerts, and IoT analytics.
Memory trick: Stream Analytics makes data flow like a river of insights.