Answer-first summary for fast verification
Answer: Use Database Migration Service to complete the migration.
To migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL with minimal downtime, the best approach is to use the Database Migration Service (DMS). DMS is designed for minimal downtime migrations by continuously replicating changes from the source to the target database until the cutover is performed. This ensures that the target database is up-to-date with the source at the time of cutover, minimizing downtime. Option A would involve significant downtime during the export and import process. Option B, Migrate for Compute Engine, is not suitable for database migrations as it is designed for VM migrations. Option C, Datastream, is a change data capture and replication service but is not specifically designed for database migrations like DMS is.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What steps should you take to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL with minimal downtime?
A
Export the data from the existing database, and load the data into a new Cloud SQL database.
B
Use Migrate for Compute Engine to complete the migration.
C
Use Datastream to complete the migration.
D
Use Database Migration Service to complete the migration.