AWS Certified Solutions Architect - Associate SAA-C03 — Topic 1 Question 771

Question

A company stores data in an on-premises Oracle relational database. The company needs to make the data available in Amazon Aurora PostgreSQL for analysis. The company uses an AWS Site-to-Site VPN connection to connect its on-premises network to AWS. The company must capture the changes that occur to the source database during the migration to Aurora PostgreSQL. Which solution will meet these requirements?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Use the AWS Schema Conversion Tool (AWS SCT) to convert the Oracle schema to Aurora PostgreSQL schema. Use AWS Database Migration Service (AWS DMS) to migrate the existing data and replicate the ongoing changes. Amazon Aurora is a high-performance managed relational database with built-in replication and failover. AWS Database Migration Service migrates databases with minimal downtime.

AWS Certified Solutions Architect - Associate SAA-C03 — Question 771