CLF-C02 Question 200
Select 2A company is planning to migrate its on-premises database to AWS. The database has a complex schema, and the target database engine in AWS differs from the on-premises database engine. Which AWS service or combination of services can assist in this migration process?
- A
AWS Database Migration Service (AWS DMS)
- B
AWS Schema Conversion Tool (AWS SCT)
- C
Amazon RDS Reserved Instances
- D
AWS Snowball
- E
AWS DataSync
Show answer and explanation
Correct answers: A, B
Explanation
When migrating databases with complex schemas, especially when the source and target database engines differ, AWS Database Migration Service (AWS DMS) is used to migrate the data, and AWS Schema Conversion Tool (AWS SCT) is used to convert the schema and code. Together, they provide a comprehensive solution for database migration. Other services like Snowball or DataSync are not specifically designed for database migrations and schema transformations.
- A. Correct.
AWS Database Migration Service (AWS DMS) is designed to migrate databases to AWS quickly and securely. It can handle homogeneous migrations (e.g., Oracle to Oracle) and heterogeneous migrations (e.g., Oracle to Amazon Aurora).
- B. Correct.
AWS Schema Conversion Tool (AWS SCT) is used to convert database schemas and code from one database engine to another, which is essential for heterogeneous migrations where the source and target database engines differ.
- C. Incorrect.
Amazon RDS Reserved Instances help reduce costs for long-term database usage but are not migration tools and do not assist with schema conversion or data transfer.
- D. Incorrect.
AWS Snowball is primarily used for transferring large volumes of data to AWS in a secure and physical manner. It is not specifically designed for database migrations.
- E. Incorrect.
AWS DataSync is used to automate moving large amounts of data between on-premises storage and AWS, but it is not tailored for database migrations or schema conversions.