This comparison is really relational vs NoSQL, and the exam tests it by workload shape and access pattern.
When to pick each
RDS is relational (SQL) — use it for structured data with complex queries, joins, and transactions. DynamoDB is NoSQL key-value/document — use it for simple, high-scale, low-latency access patterns where you know how you’ll query the data. Complex joins and reporting → RDS. Massive scale with predictable key lookups → DynamoDB.
Choosing the database in an exam scenario
Start with the access pattern, not simply the expected amount of data. Choose Amazon RDS when the application needs relational tables, SQL joins, referential integrity, or transactions across related records. Choose Amazon DynamoDB when requests can be served efficiently from a known partition key and optional sort key, and the workload needs low-latency operation at scale without managing database servers.
- Many ad hoc queries and relationships: a relational engine such as RDS is usually the stronger fit.
- Predictable key-based reads and writes: DynamoDB is often the better fit.
- High availability for RDS: Multi-AZ is for failover; read replicas primarily scale read traffic.
- DynamoDB access patterns: design keys and indexes around the queries the application must perform.
Do not select DynamoDB merely because a question says “NoSQL,” or RDS merely because the dataset is small. Match the service to consistency, query, relationship, latency, and operational requirements.
Test yourself
An app needs a database for a simple, extremely high-traffic key-value access pattern with single-digit millisecond latency at any scale. Which is best?
- Amazon RDS
- Amazon DynamoDB
- Amazon Redshift
- Amazon Athena
👉 Click to reveal the answer & explanation
Correct answer: B. DynamoDB delivers single-digit millisecond key-value access at massive scale — ideal for that pattern. RDS (A) suits complex relational queries, not extreme key-value scale; Redshift (C) is a warehouse; Athena (D) queries S3.
Related topics
Amazon RDS · Amazon DynamoDB · Amazon Aurora
Ready to pass the AWS Solutions Architect Associate (SAA-C03)?
Stop guessing whether you’re ready. Our full-length, exam-realistic practice exams put you through the exact question style you’ll face — with a detailed explanation behind every answer, so you learn why, not just what.
- ✓ 6 full-length practice exams
- ✓ A detailed explanation for every single question
- ✓ Realistic, scenario-based questions — not memory dumps
- ✓ 6 months of access to your selected certification pack
Get the SAA-C03 Practice Exams →or try 25 free questions first