Microsoft Azure Data FundamentalsDescribe how to work with non-relational data on AzureEasy
A small startup is developing a mobile game that needs to store player high scores and basic player profiles. The data volume is expected to be low initially but could scale significantly. The team needs a cost-effective, serverless solution that provides fast read/write access to simple key-value pairs. Which Azure non-relational data service is the most appropriate choice?
- AAzure Cosmos DB (SQL API)
- BAzure Table Storage
- CAzure Data Lake Storage Gen2
- DAzure Blob Storage
Show answer & explanationAnswer & explanation
Correct answer: B. Azure Table Storage
Azure Table Storage is a cost-effective, serverless key-value store ideal for high-volume, low-latency access to structured, non-relational data. It perfectly fits the requirement for storing simple player high scores and profiles without the need for complex queries or advanced features.
Why the other options are wrong
- A. Azure Cosmos DB (SQL API) offers more advanced features like global distribution and multiple consistency models at a higher cost, which is not necessary for this basic requirement.
- C. Azure Data Lake Storage Gen2 is optimized for large-scale analytics workloads and big data, which is overkill and more expensive for simple key-value storage.
- D. Azure Blob Storage is suitable for unstructured binary data like images, videos, or documents, not structured key-value pairs.
Azure Table Storage
A NoSQL data store in Azure for storing large amounts of structured, non-relational data. It's a key-value store with tables, entities, and properties.
- Cost-effective and highly scalable.
- Ideal for simple key-value data.
- Serverless and easy to use.
Memory trick: Tables are simple, blobs are big, Cosmos is complex.