Google
PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #98
You are migrating your 2 TB on-premises PostgreSQL cluster to Compute Engine. You want to set up your new environment in an Ubuntu virtual machine instance in Google Cloud and seed the data to a new…
The correct answer is C. 1. Take a full backup while the database is online. https://cloud.google.com/architecture/migrating-postgresql-to-gcp
Migrating Database Workloads
Question
You are migrating your 2 TB on-premises PostgreSQL cluster to Compute Engine. You want to set up your new environment in an Ubuntu virtual machine instance in Google Cloud and seed the data to a new instance. You need to plan your database migration to ensure minimum downtime. What should you do?
Options
- A
- Take a full export while the database is offline.
- B
- Take a full export while the database is offline.
- C
- Take a full backup while the database is online.
- D
- Take a full export while the database is online.
How the community answered
(58 responses)- A5% (3)
- B3% (2)
- C83% (48)
- D9% (5)
Explanation
https://cloud.google.com/architecture/migrating-postgresql-to-gcp
Topics
#Database Migration#PostgreSQL#Minimum Downtime#Compute Engine
Community Discussion
No community discussion yet for this question.