Google Professional Cloud Database Engineer Question 226
Select 2Google Cloud PlatformYou are tasked with migrating a large-scale on-premises MySQL database to Google Cloud. The database contains critical business data and must experience minimal downtime during the migration process. Additionally, you need to ensure data consistency throughout the migration. Which tool(s) should you use for this migration?
- A
Database Migration Service
- B
Google Cloud Storage Transfer Service
- C
Cloud SQL import/export functionality
- D
Datastream
- E
BigQuery Data Transfer Service
Show answer and explanation
Correct answers: A, D
Explanation
For a minimal downtime migration of a MySQL database to Google Cloud, Database Migration Service and Datastream are the correct tools. Database Migration Service is purpose-built for migrating databases with minimal downtime, while Datastream can supplement this by providing real-time change data capture and replication to maintain data consistency. Other options, such as Cloud Storage Transfer Service and BigQuery Data Transfer Service, are not designed for database migrations, and Cloud SQL import/export lacks the features needed for large-scale, low-downtime migrations.
- A. Correct.
Database Migration Service (DMS) is a managed service designed for database migrations to Google Cloud. It supports minimal downtime migrations for databases like MySQL, PostgreSQL, and SQL Server, making it a suitable choice for this scenario.
- B. Incorrect.
Google Cloud Storage Transfer Service is designed for transferring data between storage systems, such as moving files to Cloud Storage. It is not applicable for database migrations and does not address database-specific requirements like data consistency.
- C. Incorrect.
Cloud SQL import/export functionality is used for one-time data transfers and is not ideal for large-scale databases or scenarios requiring minimal downtime. It does not support continuous replication.
- D. Correct.
Datastream is a Google Cloud tool for real-time change data capture (CDC) and replication. It supports MySQL as a source and can be used for scenarios requiring minimal downtime and data consistency.
- E. Incorrect.
BigQuery Data Transfer Service is used for transferring data into BigQuery from external data sources such as SaaS applications. It is not suitable for migrating MySQL databases.