Google
PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #80
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?
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #80. The question stem and answer options stay visible for context.
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.
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Database Migration#PostgreSQL#Compute Engine#High Availability