AWS Certified Solutions Architect Associate · Free Practice Question Medium
Question 21
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?
- A 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.
- 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 RDS DB instance with synchronous replication to three nodes in three Availability Zones.
Reveal correct answer
Correct answer: B
Explanation
The correct solution for migrating the company's MySQL database to AWS while ensuring reliability and minimizing data loss is to create an Amazon RDS MySQL DB instance with Multi-AZ functionality enabled to synchronously replicate the data. This setup ensures that every transaction is stored on at least two nodes, providing high availability and fault tolerance.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
