Question #631
A company is migrating its enterprise applications from an on-premises data center to AWS. The company operates an Oracle database with Real Application Clusters (RAC) on-premises and wants to transition to Amazon Aurora PostgreSQL. A solutions architect must design a heterogeneous database migration using AWS managed services.
Which solution meets these requirements?
Migrate the Oracle databases to Amazon Aurora PostgreSQL using Oracle Data Pump utilities (expdp/impdp) for backup and restore.
Transfer data to Amazon S3 using an AWS Snowball Edge Storage Optimized device. Configure Amazon Aurora PostgreSQL and use S3 integration with PostgreSQL's COPY command to load data.
Convert the database schema using the AWS Schema Conversion Tool to Amazon Aurora PostgreSQL. Migrate the data using AWS Database Migration Service (AWS DMS) from on-premises Oracle to Aurora PostgreSQL.
Migrate data over the network using AWS DataSync from on-premises storage to Amazon S3. Set up Amazon Aurora PostgreSQL and load data using PostgreSQL's COPY command with S3 integration.
Explanation
Option C is correct because:
1. AWS Schema Conversion Tool (SCT) automates schema conversion from Oracle to PostgreSQL, addressing differences in data types, functions, and stored procedures.
2. AWS Database Migration Service (DMS) efficiently migrates data with minimal downtime, supporting heterogeneous database migrations.
Other options are incorrect because:
- A: Oracle Data Pump utilities (expdp/impdp) only work for Oracle-to-Oracle migrations, not PostgreSQL.
- B and D: While they transfer data via S3 and COPY commands, they do not address schema conversion, which is critical when switching database engines.
Key Points:
- Use SCT for schema conversion in heterogeneous migrations.
- Use DMS for data migration between different database engines.
- Snowball/DataSync + COPY only handle data transfer, not schema compatibility.
Answer
The correct answer is: C