Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 150

Question

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?

Accepted Answer

Correct answer: C. The correct answer is C. Option 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. Database Migration Service migrates databases to Cloud SQL/AlloyDB with minimal downtime.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 150