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

Question

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: 1. Create migration job using Database Migration Service.2. Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode.3.... 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 29