Answer-first summary for fast verification
Answer: Use Database Migration Service.
To migrate on-premises databases to Google Cloud with near-zero downtime, no application changes, and support for change data capture (CDC), the best option is to use the Database Migration Service. This service is designed specifically for such scenarios, offering a seamless migration experience with minimal downtime and support for CDC. Options A, B, and C do not fully meet the requirements as they either involve more manual steps, do not support CDC, or require application changes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the recommended approach for migrating on-premises MySQL, PostgreSQL, and Microsoft SQL Server databases to Google Cloud with minimal downtime, no application modifications, and CDC support?
A
Use the native export and import functionality of the source database.
B
Create a database on Google Cloud, and use database links to perform the migration.
C
Create a database on Google Cloud, and use Dataflow for database migration.
D
Use Database Migration Service.