Q37 — AWS SAA-C03 Ch.1
Question 37 of 65 | ← Chapter 1
Q37. 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 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 with Multi-AZ and the create a read replica in a separate AWS Region that synchronously replicates the data.
- D. Create and Amazon EC2 instance with a MySQL engine installed that triggers an AWS Lambda fucntion to synchronously replicate the data to an Amazon RDS MySQL DB instance.