Google Professional Data Engineer Question 56
Single answerGoogle Cloud PlatformYou are tasked with migrating a large on-premises MySQL database to Google Cloud with minimal downtime. The database is business-critical, and your team wants to replicate ongoing changes during the migration process to ensure data consistency. Which Google Cloud service or combination of services should you use?
- 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 best option for migrating databases like MySQL to Google Cloud with minimal downtime. It supports continuous replication to ensure data consistency during the migration process. Other options like Transfer Appliance and Datastream serve different use cases, and BigQuery Data Transfer Service is not suitable for database migrations.
- A. Incorrect.
BigQuery Data Transfer Service is used to schedule and automate the transfer of data from external sources to BigQuery. It does not support continuous replication or database migrations.
- B. Correct.
Database Migration Service is specifically designed for migrating databases like MySQL to Google Cloud with minimal downtime. It supports ongoing replication during migration, making it the correct choice for this scenario.
- C. Incorrect.
Transfer Appliance is a hardware-based solution for transferring large datasets to Google Cloud, but it is not designed for live database migrations or ongoing replication.
- D. Incorrect.
Datastream is a change data capture (CDC) and replication service. While it could be used for replication, it is not specifically designed for full end-to-end database migrations like the Database Migration Service.