CLF-C02 Question 199
Select 2Your company is migrating its on-premises Oracle database to Amazon Aurora PostgreSQL. The database schema and code need to be converted from Oracle to PostgreSQL before migration. Which combination of AWS services would you use for this process?
- A
AWS Database Migration Service (AWS DMS)
- B
AWS Schema Conversion Tool (AWS SCT)
- C
Amazon RDS Performance Insights
- D
AWS Snowball
- E
Amazon Aurora Global Database
Show answer and explanation
Correct answers: A, B
Explanation
The combination of AWS DMS and AWS SCT is ideal for migrating a database from Oracle to PostgreSQL. AWS SCT handles schema and code conversion between incompatible database engines, while AWS DMS facilitates the actual data migration with minimal downtime. Other options like Amazon RDS Performance Insights, AWS Snowball, and Amazon Aurora Global Database are not relevant to the schema conversion and migration process.
- A. Correct.
AWS Database Migration Service (AWS DMS) is used to migrate databases between different database systems, such as from Oracle to PostgreSQL, with minimal downtime.
- B. Correct.
AWS Schema Conversion Tool (AWS SCT) is used to convert the schema and code from one database engine (e.g., Oracle) to another (e.g., PostgreSQL). This is necessary when moving between incompatible database engines.
- C. Incorrect.
Amazon RDS Performance Insights is a monitoring tool for analyzing database performance and does not assist in schema conversion or migration.
- D. Incorrect.
AWS Snowball is a data transfer service designed for physically moving large volumes of data into AWS, which is not applicable in this case as the migration involves database engines.
- E. Incorrect.
Amazon Aurora Global Database is a feature that provides disaster recovery and global availability for Aurora databases but does not assist in database migration or schema conversion.