SAA-C03 Question 277
Single answerA gaming company is building a leaderboard system for their multiplayer game with millions of active users. The system requires low-latency, high-throughput performance and the ability to scale dynamically with unpredictable spikes in traffic. The leaderboard data needs to be frequently updated and queried by player rank. Which AWS database solution is the most appropriate for this use case?
- A
Amazon RDS with MySQL
- B
Amazon Aurora PostgreSQL
- C
Amazon DynamoDB
- D
Amazon Redshift
Show answer and explanation
Correct answer: C
Explanation
Amazon DynamoDB is the most appropriate database solution for this scenario because it is a NoSQL database that provides low-latency responses and can handle the high-throughput, dynamic scaling required by a leaderboard system. Other options like Amazon RDS or Aurora are better suited for traditional relational workloads, and Amazon Redshift is designed for analytical processing rather than transactional use cases.
- A. Incorrect.
Amazon RDS with MySQL is a managed relational database service, which is suitable for transactional workloads but not optimized for high-throughput, low-latency use cases like a leaderboard system. It may struggle with the scale and unpredictable spikes in traffic.
- B. Incorrect.
Amazon Aurora PostgreSQL is a highly performant relational database, but it is still a relational model. Leaderboards with frequent updates and queries by rank are better suited for NoSQL databases optimized for such workloads.
- C. Correct.
Amazon DynamoDB is a fully managed NoSQL database that supports low-latency, high-throughput workloads and is designed to scale dynamically. It is ideally suited for use cases like leaderboards where frequent updates and queries are required.
- D. Incorrect.
Amazon Redshift is a data warehouse optimized for analytical queries, not for transactional or operational workloads like leaderboards. It is not designed for low-latency or high-throughput transactional systems.