AWS Certified Solutions Architect – Associate (SAA-C03) — Question 307

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

Correct answer: B

Explanation

Amazon Aurora Serverless for MySQL is the ideal choice because it automatically scales database capacity up or down based on actual usage, which perfectly suits the infrequent access patterns and eliminates the need to pre-select a specific instance size. It also provides high availability and minimal downtime, aligning with the sales team's requirements. Other options like Amazon RDS for MySQL and provisioned Amazon Aurora MySQL require manual selection of instance types, while Amazon Redshift Spectrum is designed for querying out-of-place data warehouse files rather than hosting an active MySQL database.