Question #1035
A company needs to migrate their on-premises relational databases to AWS-managed database services while ensuring minimal downtime and continuous data replication during the process. Which AWS service or tool should they use?
AWS Glue
AWS Server Migration Service
AWS DataSync
AWS Database Migration Service (AWS DMS)
Explanation
The correct answer is D. AWS Database Migration Service (AWS DMS). AWS DMS is purpose-built for migrating relational databases to AWS-managed services (e.g., Amazon RDS, Aurora) while ensuring minimal downtime and continuous replication. It supports homogeneous (e.g., MySQL to MySQL) and heterogeneous (e.g., Oracle to Aurora) migrations, replicating ongoing changes during the migration process.
Why other options are incorrect:
- A. AWS Glue: A serverless ETL (Extract, Transform, Load) service for data preparation and analytics, not designed for database migration or replication.
- B. AWS Server Migration Service: Used for migrating on-premises virtual machines (VMs) to AWS EC2, not relational databases.
- C. AWS DataSync: Optimized for transferring large datasets between on-premises storage and AWS (e.g., S3, EFS), but lacks database replication capabilities.
Key Points:
- Use AWS DMS for database migrations requiring minimal downtime and continuous replication.
- DMS handles schema conversion, data validation, and ongoing replication.
- Other services like Glue, SMS, or DataSync do not support live database replication.
Answer
The correct answer is: D