CloudGuild · Blog · Cheat sheets · Lessons · Certifications
Exam Question Walkthrough: AWS Certified Solutions Architect - Associate (SAA-C03)
Understand the key concepts behind choosing the right database for a gaming leaderboard in the SAA-C03 exam.
A decision about database selection can trip up candidates. Understanding the specific needs of a use case is crucial. In this scenario, we need to choose the best database for a gaming leaderboard with unpredictable traffic.
The question
A single-digit-millisecond, massively scalable key-value store is needed for a gaming leaderboard with unpredictable traffic. Which database is BEST?
- A. Amazon RDS MySQL
- B. Amazon DynamoDB
- C. Amazon Redshift
- D. Amazon Neptune
Think before you scroll
Before you choose an answer, consider the requirements: low latency, scalability, and the ability to manage unpredictable traffic. Each option has distinct capabilities that cater to different use cases.
The answer
The correct option is B. Amazon DynamoDB. It is a serverless NoSQL key-value store that provides single-digit-millisecond latency at any scale. This makes it perfect for high-traffic scenarios like a gaming leaderboard.
Why the other options lose
- A. Amazon RDS MySQL: While RDS MySQL is a reliable relational database, it doesn't provide single-digit-millisecond latency at scale like DynamoDB. It also requires more management for scaling and unpredictable traffic.
- C. Amazon Redshift: This option is designed for data warehousing and analytics, not for high-speed transactions. It is optimized for complex queries over large datasets rather than real-time key-value storage.
- D. Amazon Neptune: Neptune is a graph database, suitable for applications that require relationships between data points. However, it does not meet the requirement for a key-value store with low latency.
The concept behind it
The principle here is understanding the specific database types and their strengths. DynamoDB excels in scenarios requiring quick read/write capabilities at scale, particularly when dealing with unpredictable workloads. Always match the database choice to the application's demands.
Exam trap to remember
When selecting a database for unpredictable workloads, remember: choose a key-value store for speed and scale, not a relational or graph database.