Google Cloud Professional Cloud Database Engineer — Question 19

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)

Answer options

• A. Use Database Migration Service to migrate the databases to Cloud SQL.
• B. Use a cross-region read replica to migrate the databases to Cloud SQL.
• C. Use replication from an external server to migrate the databases to Cloud SQL.
• D. Use an external read replica to migrate the databases to Cloud SQL.
• E. Use a read replica to migrate the databases to Cloud SQL.

Correct answer: A, C

Explanation

The correct answers are A and C. Option A, using Database Migration Service, allows for a streamlined migration process with minimal downtime. Option C enables replication from an external server, which helps keep the databases synchronized. The other options, while they may involve replication strategies, do not specifically address the need for minimal downtime and synchronization in the same effective manner.