AWS Certified Database – Specialty — Question 6

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle
DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.
Where should the AWS DMS replication instance be placed for the MOST optimal performance?

Answer options

• A. In the same Region and VPC of the source DB instance
• B. In the same Region and VPC as the target DB instance
• C. In the same VPC and Availability Zone as the target DB instance
• D. In the same VPC and Availability Zone as the source DB instance

Correct answer: C

Explanation

The correct answer is C because placing the AWS DMS replication instance in the same VPC and Availability Zone as the target DB instance reduces latency and improves data transfer speed during the migration. Options A and B are not optimal since they would either be too far from the target instance or not leverage the same VPC resources efficiently. Option D is also suboptimal as it would be located in the source's environment, not benefiting the target's performance.