Microsoft Certified: Azure Developer Associate (AZ-204)Develop for Azure storageMedium
A developer is building a mobile application that needs to store small amounts of structured data, such as user preferences and application settings. This data must be highly available and resilient, but does not require complex joins or relationships. The solution needs to be cost-effective for millions of entities with simple key-value lookups. Which Azure Storage solution is the most appropriate?
- AAzure Cosmos DB (Core API)
- BAzure Blob Storage
- CAzure SQL Database
- DAzure Table Storage
Show answer & explanationAnswer & explanation
Correct answer: D. Azure Table Storage
Azure Table Storage is a NoSQL key-value store optimized for large datasets of structured, non-relational data, offering high availability and cost-effectiveness for simple lookups, making it ideal for user preferences and application settings.
Why the other options are wrong
- A. Azure Cosmos DB (Core API) offers more advanced features and higher throughput, potentially more expensive than needed for simple preferences, though it could work.
- B. Azure Blob Storage is for unstructured object data (files), not structured key-value pairs.
- C. Azure SQL Database is a relational database, overkill and less cost-effective for simple key-value structured data without complex relationships.
Azure Table Storage
Azure Table Storage is a NoSQL key-value store that allows for storing large amounts of structured, non-relational data. It's highly available, scalable, and cost-effective for scenarios requiring fast lookups on simple data models.
- NoSQL key-value store.
- Stores structured, non-relational data.
- Highly scalable and available.
- Cost-effective for large datasets.
- Uses PartitionKey and RowKey for unique entity identification.
Memory trick: Tables for simple keys, Cosmos for global scale, Mongo for compatibility.