Google Professional Cloud Database Engineer Question 213
Select 3Google Cloud PlatformYour organization is planning to migrate its on-premises PostgreSQL database to Cloud SQL for PostgreSQL. The database is critical and must remain available during the migration process with minimal downtime. As a Professional Cloud Database Engineer, which of the following steps should you include in the migration strategy to achieve near-zero downtime?
- A
Set up a replica of the on-premises database in Cloud SQL and use replication to sync data in real-time.
- B
Use the Database Migration Service to perform a continuous data replication (CDC) migration.
- C
Schedule an extended maintenance window to perform a full database export and import.
- D
Enable the Cloud SQL High Availability configuration during the migration process.
- E
Create a fallback plan to revert to the on-premises database in case of migration failure.
Show answer and explanation
Correct answers: A, B, E
Explanation
To achieve near-zero downtime during migration, it is essential to use techniques like replication and continuous data replication (CDC) to sync the source and target databases in real-time. A fallback plan is also necessary to ensure business continuity in case of migration failure. Full export/import and extended maintenance windows introduce significant downtime and are not suitable for this requirement.
- A. Correct.
Correct: Setting up a replica in Cloud SQL and using replication ensures the Cloud SQL instance is synced in real-time with the on-premises database, enabling near-zero downtime during migration.
- B. Correct.
Correct: Database Migration Service supports continuous data replication (CDC), which allows you to migrate data while keeping the source database operational, minimizing downtime.
- C. Incorrect.
Incorrect: Scheduling an extended maintenance window for a full export and import introduces significant downtime, which does not align with the requirement of near-zero downtime.
- D. Incorrect.
Incorrect: Enabling High Availability in Cloud SQL improves resilience but does not directly contribute to achieving near-zero downtime during the migration process.
- E. Correct.
Correct: A fallback plan is critical to ensure you can revert to the on-premises database if issues occur during the migration, minimizing business impact.