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

Question

Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Create an external replica, and use Cloud SQL to synchronize the data to the replica. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 20