Q40 — AWS SAA-C03 Ch.10

Question 40 of 100 | ← Chapter 10

Q640. 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?

• A. Use native MySQL tools to migrate the database to Amazon RDSfor 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. Use AWS Database Migration Service (AWS DMS) to migrate the database to Amazon Aurora. Turn on Aurora Auto Scaling

Explanation

The correct migration solution that will meet the requirements is to use AWS Database Migration Service (AWS DMS) to migrate the database to Amazon Aurora and then turn on Aurora Auto Scaling. Aurora is compatible with MySQL databases, so it will maintain compatibility with the company's applications. Aurora Auto Scaling allows the database to automatically scale based on demand, ensuring that it can handle increased workload during peak periods. A is incorrect. RDS for MySQL does not scale automatically during periods of increased demand. B is incorrect. Redshift is used for data sharing purposes.D is incorrect. you muse change application codes.