Q18 — AWS SAA-C03 Ch.12

Question 18 of 100 | ← Chapter 12

Q818. 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?

• A. Use the AWS Schema Conversion Tool (AWS SCT) to convert the Oracle schema to Aurora PostgreSQL schema. Use the AWS Database Migration Service (AWS DMS) full-load migration task to migrate the data.
• B. Use AWS DataSync to migrate the data to an Amazon S3 bucket. Import the S3 data to Aurora PostgreSQL by using the Aurora PostgreSQL aws_s3 extension.
• 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. ✓
• D. Use an AWS Snowball device to migrate the data to an Amazon S3 bucket. Import the S3 data to Aurora PostgreSQL by using the Aurora PostgreSQL aws_s3 extension.

Correct Answer: 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.

Explanation

The solution that will meet the requirements is option C: Use the AWS Schema Conversion Tool (AWS SCT) to convert the Oracle schema to Aurora PostgreSQL schema and use AWS Database Migration Service (AWS DMS) to migrate the existing data and replicate the ongoing changes.The AWS Schema Conversion Tool (AWS SCT) allows you to convert the schema of your existing Oracle database to an Aurora PostgreSQL-compatible schema. This tool helps automate the schema conversion process, making it easier to migrate your database from Oracle to Aurora PostgreSQL.AWS Database Migration Service (AWS DMS) is a service that facilitates homogeneous and heterogeneous database migrations. It can be used to migrate the existing data from the on-premises Oracle database to Aurora PostgreSQL. Additionally, AWS DMS can be configured to capture and replicate ongoing changes from the source Oracle database to the target Aurora PostgreSQL database, ensuring that the changes made during the migration process are also captured and replicated.This solution allows the company to migrate the existing data from the on-premises Oracle database to Aurora PostgreSQL using AWS SCT and AWS DMS. Furthermore, it ensures that ongoing changes to the source database are captured and replicated, allowing for a seamless transition of data to Aurora PostgreSQL for analysis.