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

A company has an on-premises MySQL database that handles transactional data. The company is migrating the database to the AWS Cloud. The migrated database must maintain compatibility with the company's applications that use the database. The migrated database also must scale automatically during periods of increased demand.

Which migration solution will meet these requirements?

Answer options

• A. Use native MySQL tools to migrate the database to Amazon RDS for MySQL. Configure elastic storage scaling.
• B. Migrate the database to Amazon Redshift by using the mysqldump utility. Turn on Auto Scaling for the Amazon Redshift cluster.
• C. Use AWS Database Migration Service (AWS DMS) to migrate the database to Amazon Aurora. Turn on Aurora Auto Scaling.
• D. Use AWS Database Migration Service (AWS DMS) to migrate the database to Amazon DynamoDB. Configure an Auto Scaling policy.

Correct answer: C

Explanation

Amazon Aurora is fully compatible with MySQL, satisfying the requirement to maintain compatibility with existing applications, and its Auto Scaling feature automatically adjusts read replicas to handle transactional load. Amazon RDS for MySQL (Option A) supports storage scaling but does not scale compute/read capacity automatically in the same manner. Amazon Redshift (Option B) is a data warehouse unsuitable for transactional workloads, while Amazon DynamoDB (Option D) is a NoSQL database that would break compatibility with MySQL-based applications.