SAA-C03 Question 304
Single answerA company is planning to migrate its on-premises Oracle database to AWS. The database needs to be migrated with minimal changes to the application, and the company wants to continue using Oracle's database features. What is the most appropriate AWS service to use for this migration?
- A
Amazon RDS for Oracle
- B
Amazon Aurora with PostgreSQL compatibility
- C
Amazon DynamoDB
- D
Amazon Redshift
Show answer and explanation
Correct answer: A
Explanation
For a heterogeneous migration where the company wants to keep using Oracle's database features with minimal changes, Amazon RDS for Oracle is the best choice. The other options are either incompatible with Oracle or are designed for entirely different use cases, such as NoSQL or data warehousing.
- A. Correct.
Amazon RDS for Oracle is the correct choice because it supports the Oracle database engine, allowing the company to migrate with minimal changes and continue using Oracle's features.
- B. Incorrect.
Amazon Aurora with PostgreSQL compatibility is not suitable as it uses the PostgreSQL engine, which would require significant changes to the application and database schema.
- C. Incorrect.
Amazon DynamoDB is a NoSQL database and is not compatible with Oracle's relational database model, making it unsuitable for this use case.
- D. Incorrect.
Amazon Redshift is a data warehouse solution and is not designed for relational database workloads like those supported by Oracle.