Google Cloud Professional Cloud Database Engineer — Question 47

Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?

Answer options

• 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.

Correct answer: D

Explanation

The correct option is D, as the Database Migration Service is designed specifically for migrating databases with near-zero downtime and supports change data capture, making it ideal for this scenario. Options A and B involve methods that could lead to more downtime and require application changes, while option C, although viable, does not provide the same level of efficiency and simplicity as the Database Migration Service.