AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
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?
Explanation:
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.