AWS Certified Solutions Architect – Associate (SAA-C02) — Question 434

A company has been running a web application with an Oracle relational database in an on-premises data center for the past 15 years. The company must migrate the database to AWS. The company needs to reduce operational overhead without having to modify the application's code.
Which solution meets these requirements?

Answer options

• A. Use AWS Database Migration Service (AWS DMS) to migrate the database servers to Amazon RDS.
• B. Use Amazon EC2 instances to migrate and operate the database servers.
• C. Use AWS Database Migration Service (AWS DMS) to migrate the database servers to Amazon DynamoDB.
• D. Use an AWS Snowball Edge Storage Optimized device to migrate the data from Oracle to Amazon Aurora.

Correct answer: A

Explanation

Amazon RDS is a fully managed service that significantly reduces operational overhead for relational databases like Oracle while maintaining compatibility, meaning no application code changes are required. AWS Database Migration Service (AWS DMS) is the ideal tool to securely migrate the database to Amazon RDS. Using Amazon EC2 does not reduce operational overhead, while migrating to DynamoDB or Aurora would require significant application code modifications because they are different database paradigms or engines.