DBS-C01 · Question #175
A company is planning on migrating a 500-GB database from Oracle to Amazon Aurora PostgreSQL using the AWS Schema Conversion Tool (AWS SCT) and AWS DMS. The database does not have any stored…
The correct answer is C. For the large tables, create a table settings rule with a parallel load option in AWS DMS, then D. Use AWS DMS to set up change data capture (CDC) for continuous replication until the cutover E. Use AWS SCT to convert the schema from Oracle to Aurora PostgreSQL. https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-data-from-an-on- premises-oracle-database-to-aurora-postgresql.html
Question
A company is planning on migrating a 500-GB database from Oracle to Amazon Aurora PostgreSQL using the AWS Schema Conversion Tool (AWS SCT) and AWS DMS. The database does not have any stored procedures to migrate but has some tables that are large or partitioned. The application is critical for business so a migration with minimal downtime is preferred. Which combination of steps should a database specialist take to accelerate the migration process? (Choose three.)
Options
- AUse the AWS SCT data extraction agent to migrate the schema from Oracle to Aurora
- BFor the large tables, change the setting for the maximum number of tables to load in parallel and
- CFor the large tables, create a table settings rule with a parallel load option in AWS DMS, then
- DUse AWS DMS to set up change data capture (CDC) for continuous replication until the cutover
- EUse AWS SCT to convert the schema from Oracle to Aurora PostgreSQL.
- FUse AWS DMS to convert the schema from Oracle to Aurora PostgreSQL and for continuous
How the community answered
(44 responses)- A32% (14)
- B7% (3)
- C45% (20)
- F16% (7)
Explanation
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-data-from-an-on- premises-oracle-database-to-aurora-postgresql.html
Topics
Community Discussion
No community discussion yet for this question.