SAA-C03 Question 505
Single answerA company is planning to migrate its on-premises Oracle database to AWS. The database contains critical transactional data and must remain operational during the migration process. The company wants to minimize downtime and ensure compatibility with the Oracle database engine. Which AWS service or solution is the most appropriate for this use case?
- A
AWS Database Migration Service (DMS) with the target database as Amazon RDS for Oracle
- B
AWS Database Migration Service (DMS) with the target database as Amazon Aurora MySQL
- C
AWS Snowball Edge to transfer the database to Amazon S3 and then import it into Amazon RDS for Oracle
- D
AWS Glue for extracting, transforming, and loading (ETL) the database into Amazon DynamoDB
Show answer and explanation
Correct answer: A
Explanation
For this scenario, the company needs to perform a homogeneous migration (Oracle to Oracle) while minimizing downtime. AWS DMS is specifically designed for such use cases, as it supports live migrations and ensures seamless transfer of data with minimal impact on the source database. Using Amazon RDS for Oracle as the target ensures compatibility with the existing Oracle database engine, meeting the company's requirements.
- A. Correct.
Correct. AWS DMS supports heterogeneous and homogeneous database migrations. In this case, using DMS with Amazon RDS for Oracle as the target ensures compatibility with the existing Oracle engine while minimizing downtime during migration.
- B. Incorrect.
Incorrect. While DMS supports heterogeneous migrations, migrating from Oracle to Amazon Aurora MySQL could involve schema conversion and application changes, which are not mentioned as requirements in the scenario. This makes it less suitable for the use case.
- C. Incorrect.
Incorrect. AWS Snowball Edge is designed for physical data transfer, not live database migrations. Additionally, transferring data to Amazon S3 and then importing it into RDS would likely result in significant downtime, which the scenario aims to avoid.
- D. Incorrect.
Incorrect. AWS Glue is an ETL service designed for transforming and loading data into analytics or NoSQL databases, such as DynamoDB, but it is not a service for live database migrations or minimizing downtime.