Microsoft Certified: Azure Solutions Architect ExpertDesign data storage solutionsHard
A global logistics company needs to track millions of packages in real-time. Each package generates location updates, status changes, and sensor readings. This data needs to be ingested and processed almost instantly to provide customers with accurate tracking information. The data is high-volume and high-velocity, and requires immediate processing before being stored for historical analysis. Which Azure service should be used for the initial ingestion and real-time processing of this data?
- AAzure SQL Database
- BAzure Cosmos DB
- CAzure Data Lake Storage Gen2
- DAzure Stream Analytics
Show answer & explanationAnswer & explanation
Correct answer: D. Azure Stream Analytics
Azure Stream Analytics is a real-time analytics service designed for rapidly processing high volumes of streaming data from sources like Event Hubs or IoT Hubs. It can perform complex event processing, aggregations, and pattern matching on the fly, making it ideal for immediate package tracking updates.
Why the other options are wrong
- A. Azure SQL Database is a relational database and is not designed for real-time, high-volume stream processing directly from ingestion sources.
- B. Azure Cosmos DB is a NoSQL database for storing and querying data, not primarily for real-time stream processing and analytics on the incoming data itself.
- C. Azure Data Lake Storage Gen2 is for storing large volumes of data for batch analytics, not for real-time processing of incoming streams.
Azure Stream Analytics
Azure Stream Analytics is a fully managed, real-time analytics service that is designed to analyze and process large volumes of streaming data from multiple sources. It allows for complex event processing (CEP), aggregations, and pattern matching in real time, with SQL-like query language.
- Real-time stream processing engine
- SQL-like query language for data transformation and analysis
- Integrates with Event Hubs, IoT Hubs, and Blob Storage as inputs
- Outputs to various services like Power BI, Cosmos DB, SQL DB
Memory trick: Track packages with Stream Analytics, instant insights flow.