Microsoft Azure Data FundamentalsDescribe core data conceptsMedium
A data engineer is designing a data storage solution for an online gaming platform. The platform needs to store player profiles, game statistics, and in-game achievements. Each player profile can have a variable number of achievements and statistics, and the structure of these records may evolve over time. Which type of database would be MOST suitable for this scenario?
- ADocument Database
- BRelational Database
- CKey-Value Database
- DGraph Database
Show answer & explanationAnswer & explanation
Correct answer: A. Document Database
A document database is ideal for handling semi-structured data like player profiles, which can have varying attributes and nested structures, allowing for schema flexibility.
Why the other options are wrong
- B. Relational databases require a predefined schema, which is not flexible enough for evolving player profiles.
- C. Key-value databases are for simple, flat data structures, lacking the rich query capabilities needed for profiles.
- D. Graph databases are for complex relationships, not the primary need for player profiles and statistics.
Document Database
A NoSQL database that stores data in flexible, semi-structured document formats (like JSON or BSON).
- Schema-less, allowing for dynamic data structures.
- Ideal for handling semi-structured data and evolving data models.
- Offers rich query capabilities on document content.
Memory trick: Flexible Documents for Evolving Games