CLOUD-DIGITAL-LEADER · Question #8
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…
The correct answer is C. Database Migration Service. Database Migration Service (DMS) is Google's managed service purpose-built for migrating databases to Cloud SQL. It supports MySQL natively, performs continuous replication to keep the target in sync with the source, secures all data in transit using SSL/TLS, and enables a…
Question
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?
Options
- ABigQuery Data Transfer Service
- BMySQL batch insert
- CDatabase Migration Service
- DCloud Composer
How the community answered
(19 responses)- A5% (1)
- B11% (2)
- C84% (16)
Explanation
Database Migration Service (DMS) is Google's managed service purpose-built for migrating databases to Cloud SQL. It supports MySQL natively, performs continuous replication to keep the target in sync with the source, secures all data in transit using SSL/TLS, and enables a minimal-downtime cutover - users experience only a brief interruption during the final switch. BigQuery Data Transfer Service (A) moves data into BigQuery, not Cloud SQL. MySQL batch insert (B) is manual and requires downtime. Cloud Composer (D) is a workflow orchestration service, not a database migration tool.
Topics
Community Discussion
No community discussion yet for this question.