RDS vs Aurora vs DynamoDB for SAA-C03: Choosing the Right AWS Database

FE
FigigExams Team
Senior Network & Security Engineers · 6+ years designing and securing enterprise networks. We build the FigigExams AWS SAA exam. This guide maps to task 3.3 and 4.3 of AWS's SAA-C03 exam guide.
Aligned to the AWS SAA-C03 exam guide · Nov 2026
Try it · free · no credit card

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.

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.

The options side by side

ServiceTypeReach for it when
Amazon RDSManaged relationalStandard engines, minimal change from on-premises
Amazon AuroraRelational, MySQL and PostgreSQL compatibleHigher throughput and availability
Amazon DynamoDBKey-value and documentMassive scale, low latency, flexible schema
Amazon ElastiCacheIn-memoryCaching and sessions
Amazon RedshiftData warehouseAnalytics across large datasets

Multi-AZ vs read replicas

Multi-AZRead replica
PurposeAvailability and failoverRead scaling
ReplicationSynchronousAsynchronous
Serves readsStandard Multi-AZ standby does notYes

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.

  1. Orders need joins and transactions, which means relational. If availability and read performance are priorities, choose Aurora, otherwise RDS.
  2. Carts need simple key lookups at unpredictable scale, which suits DynamoDB in on-demand capacity mode.
  3. 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

ModeChoose when
On-demandTraffic is spiky or unknown
ProvisionedTraffic 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 saysThink
Automatic failover in the RegionRDS Multi-AZ
Offload reporting queriesRead replica
Key-value, single-digit millisecondDynamoDB
Microsecond reads on DynamoDBDAX
Too many database connections from LambdaRDS Proxy
Low-latency global reads, relationalAurora Global Database
Multi-Region writes, NoSQLDynamoDB Global Tables
Variable relational workload, little to manageAurora Serverless v2

RDS vs Aurora vs DynamoDB: practice questions

Five original questions. Each explanation says why the other options fail.

Try it · free · no credit card

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.

Study guides Free exam