AWS Certified Solutions Architect – Associate (SAA-C03) — Question 182

A company wants to migrate its MySQL database from on premises to AWS. The company recently experienced a database outage that significantly impacted the business. To ensure this does not happen again, the company wants a reliable database solution on AWS that minimizes data loss and stores every transaction on at least two nodes.

Which solution meets these requirements?

Answer options

• A. Create an Amazon RDS DB instance with synchronous replication to three nodes in three Availability Zones.
• B. Create an Amazon RDS MySQL DB instance with Multi-AZ functionality enabled to synchronously replicate the data.
• C. Create an Amazon RDS MySQL DB instance and then create a read replica in a separate AWS Region that synchronously replicates the data.
• D. Create an Amazon EC2 instance with a MySQL engine installed that triggers an AWS Lambda function to synchronously replicate the data to an Amazon RDS MySQL DB instance.

Correct answer: B

Explanation

Option B is correct because enabling Multi-AZ functionality in Amazon RDS provides synchronous replication to a standby instance in another Availability Zone, ensuring high availability and minimal data loss. Option A, while offering replication, does not specifically mention Multi-AZ, which is crucial for high availability. Option C involves cross-region replication, which is not necessary for the stated requirements of minimizing data loss within the same region. Option D relies on a custom setup that complicates the process and does not guarantee the same level of reliability as the managed service provided by Amazon RDS with Multi-AZ.