Microsoft Azure Data FundamentalsDescribe how to work with non-relational data on AzureMedium
A small startup is developing a mobile game that needs to store player high scores and basic player profiles (username, ID). The data volume is expected to be low to medium, and the primary access pattern is simple key-value lookups. Cost-effectiveness is a major concern. Which Azure non-relational data service is the most appropriate choice?
- AAzure Cosmos DB (NoSQL API)
- BAzure Data Lake Storage Gen2
- CAzure Table Storage
- DAzure Blob Storage
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Table Storage
Azure Table Storage offers a low-cost, highly scalable key-value store. For simple player profiles and high scores with basic lookups, it provides excellent performance and cost-effectiveness without the overhead of more complex NoSQL databases.
Why the other options are wrong
- A. Azure Cosmos DB is a powerful, globally distributed database, but it might be overkill and more expensive for simple key-value lookups with low to medium data volume.
- B. Azure Data Lake Storage Gen2 is for big data analytics and file systems, not for operational key-value data.
- D. Azure Blob Storage is for unstructured binary objects (files), not for structured key-value data.
Azure Table Storage
Azure Table Storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schema-less design. It's ideal for flexible datasets that don't require complex joins or foreign keys.
- Low-cost, highly scalable key-value store.
- Schema-less design, allowing flexible properties.
- Supports entities with a PartitionKey and RowKey.
- Part of Azure Storage account, offering high availability.
Memory trick: Table Storage: Simple keys, simple values, simply cost-effective.