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 non-relational database solution that can be easily integrated with Azure Functions. Which Azure service is the MOST appropriate choice?
- AAzure Cosmos DB for MongoDB
- BAzure Table Storage
- CAzure Data Lake Storage Gen2
- DAzure Blob Storage
Show answer & explanationAnswer & explanation
Correct answer: B. Azure Table Storage
Azure Table Storage offers a low-cost, serverless key-value store that is ideal for simple, flexible, and scalable non-relational data, making it well-suited for high scores and player profiles with potential for growth. Its cost-effectiveness and serverless nature align with the startup's requirements.
Why the other options are wrong
- A. Azure Cosmos DB offers more advanced features and higher performance at a higher cost, which might be overkill for initial low-volume needs.
- C. Azure Data Lake Storage Gen2 is primarily for big data analytics workloads, not transactional NoSQL data.
- D. Azure Blob Storage is for unstructured object data like images or videos, not structured key-value data.
Azure Table Storage
A NoSQL key-value store service in Azure that offers highly scalable and low-cost storage for structured, non-relational data.
- Stores data as entities with partition and row keys.
- Offers schema-less design, allowing flexible data definition.
- Cost-effective for large volumes of simple data.
- Serverless and scales automatically.
Memory trick: Think of Azure Non-Relational as flexible, scalable storage options, not rigid tables.