SAP-C02 Question 605
Select 2A company is migrating its on-premises Oracle database to Amazon Aurora PostgreSQL. During the migration, the team discovers that the schemas and database code need to be converted to ensure compatibility with Aurora PostgreSQL. The company also wants to replicate ongoing changes from the source database to the target database until the migration is complete. Which combination of AWS services should you use to achieve this?
- A
AWS Database Migration Service (AWS DMS)
- B
AWS Schema Conversion Tool (AWS SCT)
- C
Amazon RDS Multi-AZ Deployment
- D
AWS CloudFormation
- E
Amazon Aurora Backtrack
Show answer and explanation
Correct answers: A, B
Explanation
To migrate an Oracle database to Aurora PostgreSQL, AWS DMS and AWS SCT are the appropriate tools. AWS SCT is needed to convert the schema and code from Oracle to PostgreSQL, ensuring compatibility with the target database. AWS DMS is then used to migrate the data and replicate ongoing changes from the source database to the target database, ensuring minimal downtime during the migration process.
- A. Correct.
AWS DMS is used to migrate and replicate ongoing changes from the source database to the target database.
- B. Correct.
AWS SCT is used to convert the database schema and code from one database engine to another, such as Oracle to PostgreSQL.
- C. Incorrect.
Amazon RDS Multi-AZ Deployment ensures high availability for Amazon RDS but does not help with schema conversion or migration functionality.
- D. Incorrect.
AWS CloudFormation is a service to deploy and manage infrastructure as code and is not used for database schema conversion or replication.
- E. Incorrect.
Amazon Aurora Backtrack allows you to roll back your Aurora database to a previous time but is unrelated to database migration or schema conversion.