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

A company has an on-premises MySQL database used by the global sales team with infrequent access patterns. The sales team requires the database to have minimal downtime. A database administrator wants to migrate this database to AWS without selecting a particular instance type in anticipation of more users in the future.
Which service should a solutions architect recommend?

Answer options

• A. Amazon Aurora MySQL
• B. Amazon Aurora Serverless for MySQL
• C. Amazon Redshift Spectrum
• D. Amazon RDS for MySQL

Correct answer: B

Explanation

Amazon Aurora Serverless for MySQL is the ideal choice because it automatically starts up, shuts down, and scales capacity up or down based on application demand, eliminating the need to choose an instance type. This perfectly suits infrequent access patterns and accommodates future growth while maintaining high availability. Other options like Amazon RDS for MySQL and provisioned Amazon Aurora MySQL require manual selection and management of instance types, whereas Amazon Redshift Spectrum is a query service for data in Amazon S3, not a transactional MySQL database.