AWS Certified Solutions Architect Associate SAA-C03 Practice Question
A company needs a fully managed relational database engine that is compatible with MySQL and PostgreSQL and is designed for very high availability. The solution must automatically replicate data across multiple Availability Zones and be able to lose up to two copies of data without affecting write availability, and up to three copies without affecting read availability. Which AWS database engine best meets these requirements?
Amazon Aurora is a fully managed relational database service that is fully compatible with both MySQL and PostgreSQL. Aurora automatically replicates each 10 GB chunk of data six ways across three Availability Zones. Its storage layer is engineered to tolerate the loss of up to two copies of data without interrupting write operations and up to three copies without interrupting read operations, delivering higher availability than standard RDS deployments. RDS for MySQL and RDS for PostgreSQL provide managed MySQL and PostgreSQL engines but do not replicate data six times by default, and Amazon Redshift is optimized for analytics, not transactional workloads.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What features make Amazon Aurora ideal for fault tolerance and uptime?
Open an interactive chat with Bash
Why is Amazon Aurora considered compatible with Oracle databases?
Open an interactive chat with Bash
How does Amazon Aurora compare to other database engines like MySQL and PostgreSQL in terms of scalability?