GoogleGoogle
PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #80
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #80: Real Exam Question with Answer & Explanation
The correct answer is D: Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.. https://cloud.google.com/architecture/migrating-postgresql-to-gcp
Migrating Databases
Question
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?
Options
- APerform a full backup of your on-premises PostgreSQL, and then, in the migration window,
- BCreate a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
- CUse Database Migration Service to migrate your database.
- DCreate a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
Explanation
https://cloud.google.com/architecture/migrating-postgresql-to-gcp
Topics
#Database Migration#PostgreSQL#Compute Engine#High Availability
Community Discussion
No community discussion yet for this question.