Google Cloud Professional Cloud Database Engineer — Question 91

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?

Answer options

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

Correct answer: D

Explanation

The correct answer is D because Database Migration Service is specifically designed to facilitate migrations with minimal downtime. Options A, B, and C may lead to longer downtimes or are not optimized for seamless migrations compared to using the Database Migration Service.