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 (e.g., player ID, username, last login). The data model is simple, primarily key-value pairs, and the startup needs a highly scalable, low-cost solution without complex indexing or advanced querying capabilities. Which Azure non-relational data service is the most suitable?
- AAzure Table Storage
- BAzure Blob Storage
- CAzure Data Lake Storage Gen2
- DAzure Cosmos DB (SQL API)
Show answer & explanationAnswer & explanation
Correct answer: A. Azure Table Storage
Azure Table Storage is a low-cost, highly scalable NoSQL key-value store. It's ideal for simple data models like high scores and basic profiles that require fast lookups without the overhead of complex database features.
Why the other options are wrong
- B. Blob Storage is for unstructured binary data, not structured key-value pairs.
- C. Data Lake Storage Gen2 is for big data analytics, not a transactional key-value store.
- D. Cosmos DB (SQL API) offers more advanced features and higher costs than needed for simple key-value pairs.
Azure Table Storage
A NoSQL key-value store service in Azure for storing large amounts of structured, non-relational data with low cost and high scalability.
- Stores entities (rows) with properties (columns).
- Part of Azure Storage account, offering high availability.
- Ideal for simple data models, log data, and user data that doesn't require complex joins or foreign keys.
- More cost-effective than Cosmos DB for basic key-value needs.
Memory trick: For simple key-value, Table is the economical choice.