Exam Professional Cloud Database Engineer topic 1 question 5 discussion

Google-recommended practices for migrating databases to Cloud SQL emphasize using the Database Migration Service (DMS) because it is a native, managed tool that supports: Minimal downtime migrations: It supports continuous data replication using change data capture (CDC). Ease of use: DMS is fully integrated with Google Cloud, making it straightforward to configure and monitor migrations. Monitoring and reliability: It provides tools for monitoring the migration progress and detecting issues. By using DMS for both one-time and ongoing replication needs, you align with Google's best practices while reducing the complexity of using multiple tools.

database migration service can be used to migrate from on-prem and other clouds (AWS)

A is a correct answer

https://cloud.google.com/database-migration/docs/overview

https://cloud.google.com/database-migration/docs/overview

A is the correct answer here.

The question says to use Google native data migration tools

DMS will do the CDC too.

A. The question says to use Google native data migration tools. That eliminates B and D. C doesn't specify the data replication tool in question so it's a reasonable assumption its referring to database native replication which wouldn't be a Google native solution. That eliminates C. That leave A.

DMS will do the job. For the init time and the CDC phase

Option A is the most straightforward and recommended solution for migrating PostgreSQL databases to Cloud SQL while following Google-recommended practices and using native data migration tools.

A https://cloud.google.com/blog/products/databases/tips-for-migrating-across-compatible-database-engines

A is enough

A: Use Database Migration Service to migrate all databases to Cloud SQL.

C is the correct answer, we can use GCP migration tool for onetime or CDC

A for live magrations

Migrate to Cloud SQL and AlloyDB for PostgreSQL from on-premises, Google Cloud, or other clouds