AWS Certified Cloud Practitioner (CLF-C02)Cloud Technology and ServicesHard
A financial services firm needs a relational database that can automatically fail over within seconds, supports up to 15 read replicas, and offers storage that automatically scales up to 128 TB. Which AWS database service BEST meets these requirements?
- AAmazon RDS for MySQL with Multi-AZ
- BAmazon DynamoDB Global Tables
- CAmazon Redshift
- DAmazon Aurora
Show answer & explanationAnswer & explanation
Correct answer: D. Amazon Aurora
Amazon Aurora is a MySQL/PostgreSQL-compatible relational database that supports up to 15 low-latency read replicas, automatic storage scaling up to 128 TB, and fast failover (typically under 30 seconds), exceeding standard RDS capabilities.
Why the other options are wrong
- A. Standard RDS for MySQL supports only up to 5 read replicas and does not auto-scale storage to 128 TB.
- B. DynamoDB is a NoSQL database, not a relational database, so it doesn't meet the relational requirement.
- C. Redshift is a data warehouse for analytics, not an OLTP relational database with this failover/replica model.
Amazon Aurora
A MySQL/PostgreSQL-compatible relational database built for the cloud, offering higher performance, up to 15 read replicas, and storage that auto-scales to 128 TB.
- Up to 15 read replicas (vs 5 for RDS)
- Storage auto-scales up to 128 TB
- Failover typically under 30 seconds
Memory trick: Aurora = Aurora borealis lights up with 15 replicas