Google Professional Data Engineer Question 57
Single answerGoogle Cloud PlatformYour company is planning to migrate its on-premises MySQL database to Google Cloud. The database must be kept in sync with minimal downtime during the migration process. Which solution would best meet this requirement?
- A
Use the Database Migration Service to perform a continuous migration of the MySQL database to Cloud SQL.
- B
Use BigQuery Data Transfer Service to move the MySQL database to BigQuery.
- C
Use a Transfer Appliance to export the MySQL database, ship it to Google Cloud, and import it back into Cloud SQL.
- D
Use Dataproc to process and sync the MySQL database with Cloud SQL.
Show answer and explanation
Correct answer: A
Explanation
The Database Migration Service is specifically designed to migrate databases like MySQL, PostgreSQL, and SQL Server to Google Cloud with minimal downtime through continuous replication. Other options, such as BigQuery Data Transfer Service and Transfer Appliance, do not support live database migrations or are not suited for this requirement.
- A. Correct.
Correct. Database Migration Service supports continuous data replication and minimal downtime migration for MySQL databases to Cloud SQL.
- B. Incorrect.
Incorrect. BigQuery Data Transfer Service is designed to transfer data into BigQuery and is not suitable for database migrations requiring continuous replication.
- C. Incorrect.
Incorrect. While Transfer Appliance is a good choice for large offline data transfers, it does not support live replication or minimal downtime.
- D. Incorrect.
Incorrect. Dataproc is used for processing large-scale data using Hadoop or Spark but is not a tool for database migrations.