AWS Certified Solutions Architect – ProfessionalDesign for New SolutionsMedium
A global gaming company is developing a new online multiplayer game. The game backend needs to support millions of concurrent players worldwide, with extremely low latency for game state synchronization and player interactions. The data model is highly relational, with complex relationships between players, game sessions, and in-game items. The solution must be highly available and resilient to regional failures. Which database solution should be chosen?
- AAmazon DynamoDB Global Tables.
- BAmazon Redshift.
- CAmazon Neptune.
- DAmazon Aurora Global Database with MySQL compatibility.
Show answer & explanationAnswer & explanation
Correct answer: D. Amazon Aurora Global Database with MySQL compatibility.
Amazon Aurora Global Database provides a globally distributed, highly available relational database with fast cross-Region replication and low latency. Its MySQL compatibility supports the highly relational data model and complex queries, while still offering the scalability and resilience required for millions of concurrent players and regional failure recovery.
Why the other options are wrong
- A. DynamoDB Global Tables offer low latency and global distribution but are a NoSQL key-value/document database. While flexible, they are not ideal for 'highly relational data model with complex relationships' that would typically benefit from a relational database's query capabilities.
- B. Amazon Redshift is a data warehousing service, optimized for analytical processing over large datasets, not for low-latency, high-throughput transactional operations required for real-time game state synchronization and player interactions.
- C. Amazon Neptune is a graph database, ideal for highly connected data like social networks or recommendation engines. While it handles relationships, the question specifies a 'highly relational data model' which typically implies structured relational tables and SQL-like queries, not the primary use case for a graph database.
Aurora Global Database for Gaming
Leveraging Amazon Aurora Global Database to provide a scalable, low-latency, globally distributed relational database backend for multiplayer online games.
- Globally distributed relational database.
- Fast cross-Region replication (sub-second latency).
- High availability and resilience to regional failures.
- Supports complex relational data models and SQL queries.
- Scales to millions of transactions per second.
Memory trick: Relational global game, use Aurora Global's power and speed.