5. Databases

RDS (Relational Database Service)

Managed SQL DB (MySQL, Postgres, etc.).

What is the purpose of RDS Multi-AZ?

High Availability (HA) and automatic failover.

What is the purpose of an RDS Read Replica?

Performance scaling (offloads read traffic).

Aurora

High-performance, MySQL/Postgres-compatible engine.

DynamoDB

Serverless NoSQL DB; massive scalability.

Redshift

Data Warehouse (Analytics) DB.

Database Solution for high availability

RDS Multi-AZ

Database Solution for Performance

RDS Read Replica

Database Solution for Scalability

DynamoDB

Database Solution for Analytics

Redshift

Your main relational database (RDS MySQL) is struggling under heavy reporting and analytics queries. What action can immediately relieve the load on the primary instance?

Add an RDS Read Replica and direct all reporting traffic to it.

A global e-commerce platform needs a non-relational database to handle millions of transactions per second with microsecond latency. Which AWS database is the ideal fit?

DynamoDB.

An organization is migrating a massive on-premises data warehouse used for complex SQL joins and business intelligence. What AWS service should they choose?

Redshift (Analytical Data Warehouse).