AWS Certified Solutions Architect – Associate (SAA-C02) — Question 336

A company's order fulfillment service uses a MySQL database. The database needs to support a large number of concurrent queries and transactions. Developers are spending time patching and tuning the database. This is causing delays in releasing new product features.
The company wants to use cloud-based services to help address this new challenge. The solution must allow the developers to migrate the database with little or no code changes and must optimize performance.
Which service should a solutions architect use to meet these requirements?

Answer options

Correct answer: A

Explanation

Amazon Aurora is a fully managed, MySQL-compatible relational database that automates patching and administrative tasks, significantly reducing developer overhead while offering high performance and concurrency. Since it is fully compatible with MySQL, developers can migrate the database with virtually no code changes. Other options like Amazon DynamoDB would require a complete application rewrite to transition from relational to NoSQL, while running MySQL on Amazon EC2 still leaves the burden of patching and tuning on the developers.