Google Professional Cloud Database Engineer Question 227
Select 2Google Cloud PlatformYou are tasked with migrating a PostgreSQL database from an on-premises data center to Google Cloud. The database has a size of 5 TB and must experience minimal downtime during the migration. Which tool or tools should you use for this migration?
- A
Database Migration Service (DMS)
- B
Cloud SQL import/export functionality
- C
pg_dump and pg_restore
- D
Storage Transfer Service
- E
Cloud Data Transfer Appliance
Show answer and explanation
Correct answers: A, C
Explanation
Database Migration Service (DMS) is the ideal choice for migrating large PostgreSQL databases with minimal downtime because it supports continuous data replication. While pg_dump and pg_restore are more manual and not optimized for minimal downtime, they can still be used in some cases as part of a custom migration strategy. Other options, such as Cloud SQL import/export, Storage Transfer Service, and Data Transfer Appliance, do not meet the requirements for this scenario.
- A. Correct.
Database Migration Service (DMS) is the recommended tool for minimal downtime migrations of PostgreSQL databases to Google Cloud. It supports continuous data replication and is well-suited for large databases.
- B. Incorrect.
Cloud SQL import/export functionality is not suitable for large databases (such as 5 TB) or scenarios requiring minimal downtime, as it involves creating and transferring SQL dump files, which can be time-consuming.
- C. Correct.
pg_dump and pg_restore can be used for PostgreSQL database migrations, but they are better suited for smaller databases or offline migrations. However, they can still be combined with strategies for minimal downtime, such as logical replication.
- D. Incorrect.
Storage Transfer Service is used for transferring files and objects to Google Cloud Storage, not for database-specific migrations.
- E. Incorrect.
Cloud Data Transfer Appliance is designed for bulk offline transfer of large datasets to Google Cloud Storage, but it does not provide native support for database migrations or minimal downtime.