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

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.)

Accepted Answer

Correct answer: A, C. The correct answer is A, C. Option A: Use Database Migration Service to migrate the databases to Cloud SQL. Option C: Use replication from an external server to migrate the databases to Cloud SQL. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. Database Migration Service migrates databases to Cloud SQL/AlloyDB with minimal downtime.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 28