You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

Question

Options

• AExport the data from the existing database, and load the data into a new Cloud SQL database.
• BUse Migrate for Compute Engine to complete the migration.
• CUse Datastream to complete the migration.
• DUse Database Migration Service to complete the migration.

• B
  6% (1)
• C
  12% (2)
• D
  82% (14)

Explanation

Database Migration Service (DMS) is Google's fully managed service specifically designed to migrate databases to Cloud SQL with minimal downtime. It uses continuous data replication (Change Data Capture) to keep the source and destination in sync, allowing a cutover with only seconds to minutes of downtime. Option A (export/import) requires the source database to be offline or frozen during the export, causing significant downtime proportional to database size. Option B (Migrate for Compute Engine) is for lifting and shifting entire VMs, not for database-level migrations. Option C (Datastream) is a CDC streaming service that could technically be used, but DMS is the Google-recommended, purpose-built solution for this exact scenario and handles schema conversion and replication automatically.

No community discussion yet for this question.