AZ-305 Question 83
Single answerA manufacturing company is building a global IoT platform that receives large volumes of JSON sensor readings from manufacturing equipment. Each sensor may include different attributes, and the company requires low-latency access to this data from multiple regions. Which Azure service would most appropriately store and query these semi-structured sensor events?
- A
Azure Cosmos DB with the SQL (Core) API
- B
Azure SQL Database
- C
Azure Table Storage
- D
Azure Data Lake Storage Gen2
Show answer and explanation
Correct answer: A
Explanation
Semi-structured data often requires a globally distributed, highly scalable solution that can manage JSON-like documents with flexible schema. Azure Cosmos DB with the SQL (Core) API is the most suitable choice when you need low-latency access and robust global distribution for real-time queries. For additional details, see the Azure Cosmos DB documentation: https://docs.microsoft.com/azure/cosmos-db/introduction.
- A. Correct.
Azure Cosmos DB with the SQL (Core) API is correct because it offers global distribution, low latency, and flexible schema support for JSON documents. It can handle large volumes of semi-structured data and provide near real-time access for read and write operations.
- B. Incorrect.
Azure SQL Database is a good choice for structured relational data. Although it has some support for JSON functions, it is not optimized for the high ingestion rate and schema flexibility typically required by IoT workloads with unpredictable data structures.
- C. Incorrect.
Azure Table Storage is a lightweight service for key-value or table-based data. While it can store semi-structured data, it lacks more advanced querying and global distribution features compared to Azure Cosmos DB, making it less suitable for this scenario.
- D. Incorrect.
Azure Data Lake Storage Gen2 is designed for big data analytics scenarios, batch processing, and data lakes. It does not provide the same low-latency global replication or rich query capabilities that an IoT application serving real-time queries would require.