SAA-C03 Question 506
Select 2A company is planning to migrate its on-premises databases to AWS. They have a MySQL database and want to move it to Amazon RDS with minimal changes to the application and database structure. They also have an Oracle database that needs to be migrated to Amazon Aurora PostgreSQL for cost savings and advanced features. Which of the following approaches should they use for these migrations?
- A
Use the AWS Database Migration Service (DMS) to perform homogeneous migration for the MySQL database to Amazon RDS.
- B
Use AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) for the Oracle database migration to Amazon Aurora PostgreSQL.
- C
Use a manual export and import process for both the MySQL and Oracle database migrations.
- D
Use AWS Database Migration Service (DMS) for both migrations without any additional tools.
- E
Use AWS Glue for the Oracle database migration and AWS Database Migration Service (DMS) for the MySQL migration.
Show answer and explanation
Correct answers: A, B
Explanation
When migrating a database to AWS, the approach depends on whether the migration is homogeneous (same database engine) or heterogeneous (different database engines). Homogeneous migrations, such as MySQL to RDS MySQL, can be performed using AWS DMS directly. Heterogeneous migrations, such as Oracle to Aurora PostgreSQL, require schema conversion using AWS SCT before using AWS DMS for the data migration. These services ensure minimal downtime and automation during the migration process.
- A. Correct.
This is correct because AWS DMS can be used for homogeneous migrations, such as moving a MySQL database to Amazon RDS, with minimal changes.
- B. Correct.
This is correct because migrating from Oracle to Amazon Aurora PostgreSQL involves a heterogeneous migration. AWS Schema Conversion Tool (SCT) is required to convert the database schema, and AWS DMS is used for data migration.
- C. Incorrect.
This is incorrect because a manual export and import process is not the optimal solution for large-scale migrations and does not leverage AWS’s managed services for automation and reliability.
- D. Incorrect.
This is incorrect because AWS DMS alone cannot handle heterogeneous migrations. The AWS Schema Conversion Tool (SCT) is needed for schema transformation when migrating from Oracle to Amazon Aurora PostgreSQL.
- E. Incorrect.
This is incorrect because AWS Glue is not a database migration tool. It is primarily used for Extract, Transform, and Load (ETL) operations in data lakes and data pipelines.