RDS vs Aurora vs DynamoDB for SAA-C03: Choosing the Right AWS Database
Know this topic? Test it on a full SAA-C03 paper
A complete SAA-C03 practice exam: 65 questions in 130 minutes, an explanation on every item and an Exam Coach report that ranks your weakest domains.
AWS-SAA-FULL
Try a free AWS SAA exam
Already have an account? Log in to redeem
Choose RDS for a managed relational database on a standard engine, Aurora when you want higher performance and availability from MySQL or PostgreSQL compatibility, and DynamoDB for key-value access at any scale with single-digit millisecond latency. Multi-AZ is for availability; read replicas are for read scaling.Checked against AWS's published exam guide on 9 November 2026.
In this guide
The options side by side
| Service | Type | Reach for it when |
|---|---|---|
| Amazon RDS | Managed relational | Standard engines, minimal change from on-premises |
| Amazon Aurora | Relational, MySQL and PostgreSQL compatible | Higher throughput and availability |
| Amazon DynamoDB | Key-value and document | Massive scale, low latency, flexible schema |
| Amazon ElastiCache | In-memory | Caching and sessions |
| Amazon Redshift | Data warehouse | Analytics across large datasets |
Multi-AZ vs read replicas
| Multi-AZ | Read replica | |
|---|---|---|
| Purpose | Availability and failover | Read scaling |
| Replication | Synchronous | Asynchronous |
| Serves reads | Standard Multi-AZ standby does not | Yes |
What Aurora adds
- Storage replicates six copies across three Availability Zones.
- Aurora Serverless v2 scales capacity automatically for variable workloads.
- Aurora Global Database serves low-latency reads across Regions and supports DR.
What DynamoDB adds
- On-demand or provisioned capacity.
- DAX provides microsecond reads with minimal code change.
- Global Tables provide multi-Region, multi-active replication.
- DynamoDB Streams trigger processing when items change.
Connections and caching
RDS Proxy pools connections, which helps Lambda functions that would otherwise open too many. Use ElastiCache to take read load off a relational database, and DAX when the database is DynamoDB.
A worked scenario: picking between them
Requirement: an orders system needs transactions and reporting joins, and a separate shopping-cart feature needs huge, spiky traffic with simple key lookups.
- Orders need joins and transactions, which means relational. If availability and read performance are priorities, choose Aurora, otherwise RDS.
- Carts need simple key lookups at unpredictable scale, which suits DynamoDB in on-demand capacity mode.
- If cart reads must be microsecond, add DAX. If order reports slow the writer, add a read replica.
One database rarely has to do everything. The guide's phrase is purpose-built AWS services.
DynamoDB capacity modes
| Mode | Choose when |
|---|---|
| On-demand | Traffic is spiky or unknown |
| Provisioned | Traffic is predictable, and you want to control cost |
Operational details that get tested
- Encrypting an existing unencrypted RDS database: take a snapshot, copy it with encryption on, and restore from the copy.
- Read replicas can be promoted to standalone databases, including for cross-Region DR.
- RDS storage autoscaling grows storage automatically when space runs low.
- Migrations: AWS DMS moves the data. Add the Schema Conversion Tool when the engines differ (heterogeneous).
- Automated backups enable point-in-time restore. Manual snapshots persist until you delete them.
How the exam words it
| If the question says | Think |
|---|---|
| Automatic failover in the Region | RDS Multi-AZ |
| Offload reporting queries | Read replica |
| Key-value, single-digit millisecond | DynamoDB |
| Microsecond reads on DynamoDB | DAX |
| Too many database connections from Lambda | RDS Proxy |
| Low-latency global reads, relational | Aurora Global Database |
| Multi-Region writes, NoSQL | DynamoDB Global Tables |
| Variable relational workload, little to manage | Aurora Serverless v2 |
RDS vs Aurora vs DynamoDB: practice questions
Five original questions. Each explanation says why the other options fail.
Your free AWS SAA exam code is ready
Sit the full SAA-C03 paper against the real 130-minute clock. AWS SAA is $39 once, lifetime, future versions included.
AWS-SAA-FULL
Redeem the code
Already have an account? Log in to redeem
Frequently asked questions
What is the difference between RDS Multi-AZ and a read replica?
Multi-AZ is for availability, using synchronous replication and automatic failover. Read replicas are for read scaling, using asynchronous replication.
When should I use DynamoDB instead of RDS?
When you need key-value access at very large scale with low latency and a flexible schema. RDS suits relational data with joins and transactions on standard engines.
Is Aurora better than RDS?
Aurora offers higher performance and resilience for MySQL and PostgreSQL workloads, but costs more. RDS suits standard engines with minimal change.
Should I choose Redis or Memcached on ElastiCache?
Choose Redis OSS or Valkey when you need replication, persistence, high availability or rich data types. Memcached is the simple, multi-threaded option with no replication. For DynamoDB specifically, the exam's microsecond answer is DAX.