SAA-C03 Question 302
Single answerYour company is planning to migrate its on-premises database infrastructure to AWS. Currently, the database uses an Oracle engine, and the team is considering migrating to a fully managed relational database service on AWS. The team has decided to migrate to an open-source database engine to reduce licensing costs. Which migration path and AWS service combination is BEST suited for this use case?
- A
Use AWS Database Migration Service (DMS) for a heterogeneous migration to Amazon RDS for PostgreSQL.
- B
Use AWS Database Migration Service (DMS) for a homogeneous migration to Amazon RDS for Oracle.
- C
Use AWS Database Migration Service (DMS) for a heterogeneous migration to Amazon Aurora for MySQL.
- D
Use AWS Database Migration Service (DMS) for a homogeneous migration to Amazon RDS for MySQL.
Show answer and explanation
Correct answer: A
Explanation
In this scenario, the company is migrating from an Oracle database to an open-source engine to reduce licensing costs. A heterogeneous migration is required because the source (Oracle) and target (PostgreSQL) database engines are different. AWS Database Migration Service (DMS) is the ideal tool for this purpose, as it supports heterogeneous migrations. Amazon RDS for PostgreSQL is a managed, open-source database service that meets the company’s cost-saving goals.
- A. Correct.
This is the correct choice because the company wants to move from Oracle to an open-source database engine to save on licensing costs. PostgreSQL is a popular open-source relational database that is compatible with AWS Database Migration Service (DMS) for heterogeneous migrations.
- B. Incorrect.
This option is incorrect because the company explicitly wants to move away from Oracle to an open-source database engine. A homogeneous migration to Amazon RDS for Oracle does not align with the cost-saving requirements outlined in the scenario.
- C. Incorrect.
While Amazon Aurora for MySQL is open-source compatible, this option is incorrect because the question does not specify the team’s preference for MySQL over PostgreSQL. PostgreSQL is a better fit based on the scenario described.
- D. Incorrect.
This option is incorrect because a homogeneous migration (where the source and target databases use the same engine) is not applicable in this case. The company is migrating from Oracle to an open-source database engine, making this option invalid.