Answer-first summary for fast verification
Answer: Use Database Migration Service to migrate the databases to Cloud SQL., Use replication from an external server to migrate the databases to Cloud SQL.
To ensure minimal downtime and keep the Google Cloud databases in sync with the on-premises data changes until the applications can cut over, the best approaches are to use the Database Migration Service (C) and replication from an external server (E). The Database Migration Service is designed for minimal downtime migrations and supports continuous data replication from the source to the target database. Replication from an external server (E) is also a valid method as it allows for the synchronization of data between the on-premises databases and Cloud SQL instances until the cutover is complete. Options A, B, and D involve read replicas, which are not suitable for initial migrations from on-premises to Cloud SQL as they require the database to already be in Google Cloud.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you minimize downtime and maintain synchronization between on-premises MySQL/PostgreSQL databases and Google Cloud during a data center migration, given limited operational capacity for backups and ongoing production releases? (Select two options.)
A
Use an external read replica to migrate the databases to Cloud SQL.
B
Use a read replica to migrate the databases to Cloud SQL.
C
Use Database Migration Service to migrate the databases to Cloud SQL.
D
Use a cross-region read replica to migrate the databases to Cloud SQL.
E
Use replication from an external server to migrate the databases to Cloud SQL.
No comments yet.