Microsoft Azure Data FundamentalsDescribe how to work with non-relational data on AzureHard
A development team is building a high-performance web application that requires storing millions of small key-value pairs. Each key-value pair represents a user setting and needs extremely low-latency read and write access. The data does not require complex queries or relationships. Which Azure non-relational data service is the most cost-effective and performant for this specific requirement?
- AAzure Cosmos DB (SQL API)
- BAzure Table Storage
- CAzure Blob Storage
- DAzure Data Lake Storage Gen2
Show answer & explanationAnswer & explanation
Correct answer: B. Azure Table Storage
Azure Table Storage is a NoSQL key-value store optimized for storing large amounts of structured, non-relational data. It offers incredibly low-cost storage and high-performance access for simple lookups based on primary key (partition key and row key), making it ideal for millions of small key-value pairs without complex query needs.
Why the other options are wrong
- A. Azure Cosmos DB (SQL API) is a document database that can handle key-value, but it's generally more expensive and offers more features (e.g., global distribution, higher consistency levels, complex querying) than needed for simple key-value pairs, making it less cost-effective for this specific scenario.
- C. Azure Blob Storage is for unstructured object data, not structured key-value pairs that require direct, low-latency access for individual items.
- D. Azure Data Lake Storage Gen2 is for big data analytics and file systems, not optimized for transactional key-value lookups.
Azure Table Storage
A NoSQL key-value store service for structured data, offering low-cost and scalable storage.
- Stores large amounts of structured, non-relational data.
- Cost-effective for millions of entities.
- Offers fast access using a primary key (PartitionKey, RowKey).
- Part of Azure Storage account, simpler than Cosmos DB.
Memory trick: Tables for simple keys, Cosmos for complex documents.