Answer-first summary for fast verification
Answer: Use AWS Database Migration Service (AWS DMS) to migrate the database to Amazon Aurora. Turn on Aurora Auto Scaling.
## Explanation **Option C is correct** because: 1. **Compatibility**: Amazon Aurora is MySQL-compatible, so existing applications that work with MySQL will work with Aurora without modification. 2. **Migration**: AWS Database Migration Service (AWS DMS) is specifically designed for database migrations with minimal downtime. 3. **Auto Scaling**: Aurora Auto Scaling automatically adjusts the number of Aurora Replicas based on the workload, providing automatic scaling during periods of increased demand. **Why other options are incorrect**: - **Option A**: While RDS for MySQL is compatible, elastic storage scaling only scales storage, not compute capacity. It doesn't provide automatic scaling of database instances during increased demand. - **Option B**: Amazon Redshift is a data warehouse solution, not a transactional database. It's not MySQL-compatible for transactional workloads, and using mysqldump is not the recommended migration approach for Redshift. - **Option D**: DynamoDB is a NoSQL database, not MySQL-compatible. Applications designed for MySQL would need significant rewriting to work with DynamoDB. **Key AWS Services**: - **AWS DMS**: For seamless database migration - **Amazon Aurora**: MySQL-compatible, high-performance database with auto-scaling capabilities - **Aurora Auto Scaling**: Automatically adds/removes read replicas based on CPU utilization or connections
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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 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.