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

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 allows for synchronous replication of data, ensuring high availability and minimizing data loss. Option A, while it mentions multiple nodes, does not specifically mention the Multi-AZ feature, which is essential for this use case. Option C involves a read replica, which is typically asynchronous and does not meet the requirement for synchronous replication. Option D introduces unnecessary complexity with EC2 and Lambda, which does not offer the same level of reliability as the built-in RDS Multi-AZ feature.