A Company Wants to Migrate Its MySQL Database from on Premises

question 343

Multiple Choice

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 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.

---

Definitions:

Log-transformed

Data that has been converted using the logarithmic scale, often to stabilize the variance or normalize the distribution.

Independent Research Firm

An organization that conducts studies and analysis without affiliation to any parties that may influence the outcomes.

Sports Drinks

Drinks formulated to assist sportspeople in rehydrating, along with restoring electrolytes, sugar, and various nutrients, amid or following exercise.

ANOVA

Analysis of Variance, a statistical method used to assess whether there are significant differences between the means of three or more groups.