SAA-C03 Question 305
Single answerA company is planning to migrate its on-premises Oracle database to AWS. The team wants to minimize the migration effort and downtime while keeping the database engine unchanged. Which AWS service and approach should they use?
- A
Use AWS Database Migration Service (DMS) for a homogeneous migration to Amazon RDS for Oracle.
- B
Use AWS Database Migration Service (DMS) for a heterogeneous migration to Amazon Aurora.
- C
Use AWS Snowball Edge to migrate the Oracle database to Amazon DynamoDB.
- D
Use AWS Glue to migrate the Oracle database to Amazon Redshift.
Show answer and explanation
Correct answer: A
Explanation
When migrating databases with minimal effort and downtime, AWS Database Migration Service (DMS) is the preferred choice. A homogeneous migration keeps the database engine unchanged (Oracle to Amazon RDS for Oracle). This ensures compatibility and minimizes the need for schema or application changes. The other options involve either changing the database engine or using services not suitable for this use case.
- A. Correct.
This is the correct option. A homogeneous migration involves keeping the database engine unchanged. Using DMS with Amazon RDS for Oracle minimizes downtime and retains the Oracle engine.
- B. Incorrect.
This is incorrect. A heterogeneous migration involves changing the database engine, such as moving from Oracle to Aurora. This would require additional effort for schema conversion.
- C. Incorrect.
This is incorrect. AWS Snowball Edge is used for large-scale data transfer but is not suitable for database migrations that require minimal downtime or maintaining the Oracle engine.
- D. Incorrect.
This is incorrect. AWS Glue is a data integration service and is not typically used for database migrations. Additionally, migrating to Redshift would involve changing the engine, which is not the goal in this scenario.