AWS Certified Solutions Architect – Associate (SAA-C02) — Question 537

A company is running a multi-tier ecommerce web application in the AWS Cloud. The web application is running on Amazon EC2 instances. The database tier is on a provisioned Amazon Aurora MySQL DB cluster with a writer and a reader in a Multi-AZ environment. The new requirement for the database tier is to serve the application to achieve continuous write availability through an instance failover.
What should a solutions architect do to meet this new requirement?

Answer options

• A. Add a new AWS Region to the DB cluster for multiple writes.
• B. Add a new reader in the same Availability Zone as the writer.
• C. Migrate the database tier to an Aurora multi-master cluster.
• D. Migrate the database tier to an Aurora DB cluster with parallel query enabled.

Correct answer: C

Explanation

Amazon Aurora Multi-Master clusters allow the creation of multiple writer instances within a single DB cluster, ensuring continuous write availability because applications can immediately route write operations to another active writer if one fails. Adding a reader instance or enabling parallel query does not provide write availability during a failover event. Multi-region deployments are intended for disaster recovery and global latency reduction, not for local continuous write availability during an instance failover.