Google Professional Data Engineer Question 55
Single answerGoogle Cloud PlatformYour company is planning to migrate an on-premises MySQL database with a high data change rate to Google Cloud. The goal is to minimize downtime during the migration and ensure continuous replication of data changes to the cloud database. Which Google Cloud service should you use to achieve this?
- A
BigQuery Data Transfer Service
- B
Database Migration Service
- C
Transfer Appliance
- D
Datastream
Show answer and explanation
Correct answer: B
Explanation
Database Migration Service is the recommended solution for migrating MySQL databases to Google Cloud while ensuring minimal downtime. It supports continuous replication, which is essential for databases with high data change rates and ensures a smooth transition to Cloud SQL or other compatible Google Cloud databases.
- A. Incorrect.
BigQuery Data Transfer Service is used for scheduled, batch data transfers from external sources into BigQuery and is not suitable for database replication or handling high data change rates.
- B. Correct.
Database Migration Service (DMS) is the correct tool for this scenario, as it supports continuous replication for MySQL databases with minimal downtime during migrations to Google Cloud databases like Cloud SQL.
- C. Incorrect.
Transfer Appliance is a physical device used for transferring large datasets to Google Cloud, but it does not support ongoing replication or handle high data change rates.
- D. Incorrect.
Datastream is a serverless change data capture (CDC) and replication service, but it is better suited for use cases like streaming data into BigQuery or other services rather than direct database migrations.