Answer-first summary for fast verification
Answer: Utilize AWS Schema Conversion Tool and AWS DMS with a memory-optimized instance for full load plus CDC replication and table mapping.
The correct answer is C. The AWS Schema Conversion Tool helps in converting database schema to Aurora PostgreSQL. Using AWS Database Migration Service (AWS DMS) with a memory-optimized instance ensures efficient handling of high read-write volumes. Creating a full load plus change data capture (CDC) replication task ensures that the data is synchronized between the Oracle database and Amazon Aurora PostgreSQL throughout the migration process. This setup supports selecting all tables, ensuring a comprehensive data migration.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A company is migrating its Oracle database to Amazon Aurora PostgreSQL, with applications writing to shared tables. Migrations are staggered monthly. How should a solutions architect ensure data synchronization during the transition, considering high read-write volumes?
A
Perform initial migration with AWS DataSync, then set up CDC replication and table mapping in AWS DMS.
B
Execute initial migration with AWS DataSync, followed by full load plus CDC replication and comprehensive table mapping in AWS DMS.
C
Utilize AWS Schema Conversion Tool and AWS DMS with a memory-optimized instance for full load plus CDC replication and table mapping.
D
Employ AWS Schema Conversion Tool and AWS DMS with a compute-optimized instance, focusing CDC replication and table mapping on the largest tables.