PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #104
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 releas
The correct answer is C. Use Database Migration Service to migrate the databases to Cloud SQL. E. Use replication from an external server to migrate the databases to Cloud SQL.. Database Migration Service (DMS) combined with Cloud SQL's external server replication together provide continuous synchronization from on-premises databases to Cloud SQL with minimal downtime, allowing applications to cut over at any time.
Question
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.)
Options
- AUse an external read replica to migrate the databases to Cloud SQL.
- BUse a read replica to migrate the databases to Cloud SQL.
- CUse Database Migration Service to migrate the databases to Cloud SQL.
- DUse a cross-region read replica to migrate the databases to Cloud SQL.
- EUse replication from an external server to migrate the databases to Cloud SQL.
How the community answered
(20 responses)- A5% (1)
- B5% (1)
- C75% (15)
- D15% (3)
Why each option
Database Migration Service (DMS) combined with Cloud SQL's external server replication together provide continuous synchronization from on-premises databases to Cloud SQL with minimal downtime, allowing applications to cut over at any time.
An external read replica is a Cloud SQL concept where Cloud SQL itself replicates from an external primary; this is largely equivalent to option E but described less precisely, making E the more accurate and specific answer.
A standard read replica within Cloud SQL replicates data from a Cloud SQL primary instance, not from an on-premises database, so it cannot keep the Cloud SQL instance in sync with on-premises changes.
Database Migration Service automates the initial data migration and uses CDC to continuously replicate changes from on-premises MySQL and PostgreSQL databases to Cloud SQL, requiring minimal DBA effort and keeping the Cloud SQL instance in sync until application cutover. Option E (replication from an external server) is the underlying mechanism Cloud SQL uses to stay synchronized with an external source database during migration, enabling zero-downtime cutover by promoting the Cloud SQL instance when ready.
A cross-region read replica replicates data between Cloud SQL instances in different regions, not from on-premises databases to Cloud SQL.
Concept tested: Cloud SQL migration with DMS and external server replication
Source: https://cloud.google.com/database-migration/docs/mysql/migration-overview
Topics
Community Discussion
No community discussion yet for this question.