Google Cloud Digital Leader — Question 43

Your organization is moving an application to Google Cloud. As part of that effort, it needs to migrate the application's working database from another cloud provider to Cloud SQL. The database runs on the MySQL engine. The migration must cause minimal disruption to users. Data must be secured while in transit.
Which should your organization use?

Answer options

• A. BigQuery Data Transfer Service
• B. MySQL batch insert
• C. Database Migration Service
• D. Cloud Composer

Correct answer: C

Explanation

The Database Migration Service is specifically designed for migrating databases with minimal downtime and ensures data security during transit, making it the most suitable option. In contrast, the BigQuery Data Transfer Service is intended for data analytics rather than direct database migration, MySQL batch insert is not designed for live migrations, and Cloud Composer is used for workflow orchestration, not database transfer.