AWS Certified SysOps Administrator – Associate — Question 59

A company hosts several write-intensive applications. These applications use a MySQL database that runs on a single Amazon EC2 instance. The company asks a SysOps administrator to implement a highly available database solution that is ideal for multi-tenant workloads.

Which solution should the SysOps administrator implement to meet these requirements?

Answer options

• A. Create a second EC2 instance for MySQL. Configure the second instance to be a read replica.
• B. Migrate the database to an Amazon Aurora DB cluster. Add an Aurora Replica.
• C. Migrate the database to an Amazon Aurora multi-master DB cluster.
• D. Migrate the database to an Amazon RDS for MySQL DB instance.

Correct answer: C

Explanation

The correct answer is C because an Amazon Aurora multi-master DB cluster allows for multiple write nodes, which is ideal for write-intensive, multi-tenant workloads, ensuring high availability and scalability. Option A only adds a read replica, which does not meet the write requirements. Option B, while it enhances read capacity, does not provide multiple write capabilities. Option D also lacks the multi-master feature necessary for high availability in write-heavy scenarios.