Google Cloud Professional Cloud Database Engineer — Question 160

You are planning the migration of a large Oracle database to AlloyDB for PostgreSQL. The database contains a large amount of application logic written as stored procedures that needs to be migrated to the target database. You want to minimize both migration effort and downtime for the migration. What should you do?

Answer options

• A. Use Ora2pg for schema and code conversion and data migration.
• B. Use Ora2pg for schema and code conversion. Use the oracle_fdw extension in AlloyDB and replicate data from source to destination by using CREATE TABLE AS SELECT statements.
• C. Use Database Migration Service. Set up a conversion workspace for schema and code conversion. Create a migration job to perform backfill and change data capture to replicate data from source to destination.
• D. Use Database Migration Service. Set up a legacy conversion workspace for schema and code conversion. Create a migration job to perform backfill and change data capture to replicate data from source to destination.

Correct answer: C

Explanation

The correct answer is C because using Database Migration Service with a conversion workspace allows for efficient schema and code conversion, along with the ability to perform backfill and change data capture, minimizing downtime. Options A and B do not fully address the need for change data capture, and D specifies a legacy workspace which may not be as effective as the standard conversion workspace in this context.