Answer-first summary for fast verification
Answer: Amazon RDS MySQL DB instance with Multi-AZ enabled for synchronous replication.
The correct answer is B. Amazon RDS MySQL DB instance with Multi-AZ enabled provides synchronous replication to a standby instance in a different availability zone, which ensures minimal data loss and high availability. This setup replicates data synchronously, ensuring each transaction is stored on at least two nodes, thus meeting the company's requirements for reliability and minimizing data loss.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A company seeks to migrate its MySQL database to AWS, prioritizing a solution that minimizes data loss and ensures every transaction is stored on at least two nodes after a recent outage. Which AWS database solution meets these criteria?
A
Amazon RDS DB instance with synchronous replication across three Availability Zones.
B
Amazon RDS MySQL DB instance with Multi-AZ enabled for synchronous replication.
C
Amazon RDS MySQL DB instance with a synchronous read replica in a different AWS Region.
D
EC2 instance with MySQL and an AWS Lambda-triggered synchronous replication to RDS MySQL.
No comments yet.