Google Professional Cloud Database Engineer Question 225
Select 2Google Cloud PlatformYour company is migrating a MySQL database hosted on-premises to Cloud SQL for MySQL. The database contains 5 TB of data and has minimal downtime requirements, as it supports a critical application. Which combination of tools would you use to ensure an efficient and reliable migration?
- A
Database Migration Service (DMS)
- B
Cloud Storage Transfer Service
- C
mysqldump and manual import
- D
Replication using Database Migration Service
- E
BigQuery Data Transfer Service
Show answer and explanation
Correct answers: A, D
Explanation
To migrate a large MySQL database with minimal downtime, Database Migration Service (DMS) is the most appropriate tool. It supports replication, which enables you to keep the source and target databases in sync until you're ready to perform a cutover with minimal disruption. Other tools, such as mysqldump or Cloud Storage Transfer Service, are either inefficient for large datasets or not designed for database migrations.
- A. Correct.
Database Migration Service (DMS) is the recommended tool for migrating MySQL databases to Cloud SQL. It supports minimal downtime migrations by leveraging replication.
- B. Incorrect.
Cloud Storage Transfer Service is typically used for transferring large files into Cloud Storage and is not designed for database migrations.
- C. Incorrect.
Using mysqldump and manual import can work for smaller databases, but it is not suitable for large databases with minimal downtime requirements due to the long export/import times.
- D. Correct.
Replication using Database Migration Service allows continuous syncing of the source database to the target database, ensuring minimal downtime during the transition.
- E. Incorrect.
BigQuery Data Transfer Service is used for transferring data into BigQuery, not for migrating relational MySQL databases to Cloud SQL.