AWS Certified Solutions Architect – Professional — Question 980

A company wants to move an application from on premises to the AWS Cloud. The application uses MySQL servers to store backend data. However, the application does not scale properly. The databases have become unresponsive as the user base has increased.
The company needs a solution to make the application highly available with low latency across multiple AWS Regions. The solution must require the least possible operational overhead and development effort.
Which solution will meet these requirements?

Answer options

• A. Create an Amazon RDS for MySQL DB cluster that includes a cross-Region read replica. Use AWS Database Migration Service (AWS DMS) to migrate existing databases.
• B. Deploy Amazon DynamoDB with global tables. Use AWS Database Migration Service (AWS DMS) to migrate existing databases. Adapt the application to work with DynamoDB.
• C. Create an Amazon Aurora global database. Use native MySQL tools to migrate existing databases.
• D. Create MySQL servers on Amazon EC2 instances in two Regions. Set up asynchronous software replication across Regions.

Correct answer: C

Explanation

Amazon Aurora is a fully managed, MySQL-compatible database service, meaning migrating to it requires no development effort to rewrite application code, and native MySQL tools can be used for the migration. Implementing an Amazon Aurora global database provides low-latency reads and high availability across multiple AWS Regions with minimal operational overhead. Other options either require significant code modifications to transition to a NoSQL database like Amazon DynamoDB, or demand high operational overhead to manage database replication on Amazon EC2 or Amazon RDS.