SAA-C03 · Question #56
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…
The correct answer is C. Use the AWS Schema Conversion Tool (AWS SCT) to convert the Oracle schema to Aurora. For the migration of data from an on-premises Oracle database to Amazon Aurora PostgreSQL, this solution effectively handles schema conversion, data migration, and ongoing data replication. AWS Schema Conversion Tool (SCT): SCT is used to convert the Oracle database schema to a…
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?
Options
- AUse the AWS Schema Conversion Tool (AWS SCT) to convert the Oracle schema to Aurora
- BUse AWS DataSync to migrate the data to an Amazon S3 bucket. Import the S3 data to Aurora
- CUse the AWS Schema Conversion Tool (AWS SCT) to convert the Oracle schema to Aurora
- DUse an AWS Snowball device to migrate the data to an Amazon S3 bucket. Import the S3 data to
How the community answered
(38 responses)- A13% (5)
- B5% (2)
- C79% (30)
- D3% (1)
Explanation
For the migration of data from an on-premises Oracle database to Amazon Aurora PostgreSQL, this solution effectively handles schema conversion, data migration, and ongoing data replication. AWS Schema Conversion Tool (SCT): SCT is used to convert the Oracle database schema to a format compatible with Aurora PostgreSQL. This tool automatically converts the database schema and code objects, like stored procedures, to the target database engine. AWS Database Migration Service (DMS): DMS is employed to perform the data migration. It supports both full- load migrations (for initial data transfer) and continuous replication of ongoing changes (Change Data Capture, or CDC). This ensures that any updates to the Oracle database during the migration are captured and applied to the Aurora PostgreSQL database, minimizing downtime. Why Not Other Options? Option A (SCT + DMS full-load only): This option does not capture ongoing changes, which is crucial for a live database migration to ensure data consistency. Option B (DataSync + S3): AWS DataSync is more suited for file transfers rather than database migrations, and it doesn't support ongoing change replication. Option D (Snowball + S3): Snowball is typically used for large-scale data transfers that don't require continuous synchronization, making it less suitable for this scenario where ongoing changes must be captured.
Community Discussion
No community discussion yet for this question.