SAA-C03 Question 303
Single answerA company wants to migrate its on-premises Oracle database to AWS with minimal downtime. The company also plans to keep using Oracle as the database engine in AWS. Which AWS service is most appropriate for this use case?
- A
AWS Database Migration Service (DMS)
- B
Amazon Aurora
- C
Amazon RDS for Oracle
- D
Amazon DynamoDB
Show answer and explanation
Correct answer: A
Explanation
For a homogeneous migration like Oracle to Oracle, AWS Database Migration Service (DMS) is the most suitable option as it supports minimal downtime and simplifies the migration process. While Amazon RDS for Oracle can host the Oracle database after the migration, it does not facilitate the migration itself.
- A. Correct.
AWS Database Migration Service (DMS) is specifically designed for database migrations, including homogeneous migrations (Oracle to Oracle). It supports minimal downtime migrations and is ideal for this use case.
- B. Incorrect.
Amazon Aurora is a relational database engine compatible with MySQL and PostgreSQL. It is not suitable for directly migrating to an Oracle database.
- C. Incorrect.
Amazon RDS for Oracle is a managed Oracle database service. While it can host the Oracle database post-migration, it does not handle the actual migration process.
- D. Incorrect.
Amazon DynamoDB is a NoSQL database and is not relevant for migrating relational Oracle databases.