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

Question

Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: 1. Use Database Migration Service to connect to your on-premises database, and choose continuous replication.2. After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applica... 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 104