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 (A) and replication from an external server (C). 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 (C) is also a viable option as it allows for the synchronization of data between the on-premises databases and Cloud SQL instances until the cutover is complete. Options B, D, and E involve read replicas, which are not suitable for initial migration scenarios where the source and target databases need to stay in sync until the cutover, as read replicas are primarily used for scaling read operations and not for migration purposes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you minimize downtime and maintain synchronization between on-premises MySQL and PostgreSQL databases and Google Cloud during migration, given limited team capacity and ongoing production releases? (Select two 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.
No comments yet.