Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Google Discussions

Exam Professional Cloud Database Engineer topic 1 question 126 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 126
Topic #: 1
[All Professional Cloud Database Engineer Questions]

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?

  • A. 1. Take a full export while the database is offline.
    2. Create a bucket in Cloud Storage.
    3. Transfer the dump file to the bucket you just created.
    4. Import the dump file into the Google Cloud primary server.
    B.1. Take a full export while the database is offline.
    2. Create a bucket in Cloud Storage.
    3. Transfer the dump file to the bucket you just created.
    4. Restore the backup into the Google Cloud primary server.
  • C. 1. Take a full backup while the database is online.
    2. Create a bucket in Cloud Storage.
    3. Transfer the backup to the bucket you just created.
    4. Restore the backup into the Google Cloud primary server.
    5. Create a recovery.conf file in the $PG_DATA directory.
    6. Stop the source database.
    7. Transfer the write ahead logs to the bucket you created before.
    8. Start the PostgreSQL service.
    9. Wait until Google Cloud primary server syncs with the running primary server.
  • D. 1. Take a full export while the database is online.
    2. Create a bucket in Cloud Storage.
    3. Transfer the dump file and write-ahead logs to the bucket you just created.
    4. Restore the dump file into the Google Cloud primary server.
    5. Create a recovery.conf file in the $PG_DATA directory.
    6. Stop the source database.
    7. Transfer the write-ahead logs to the bucket you created before.
    8. Start the PostgreSQL service.
    9. Wait until the Google Cloud primary server syncs with the running primary server.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by AnilKr at March 24, 2023, 5:25 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Pime13
2 weeks, 3 days ago
c: https://cloud.google.com/architecture/migrating-postgresql-to-gcp
upvoted 1 times
...
njda
8 months, 1 week ago
Selected Answer: C
Couple of reasons for C option. 1. Database remains online (see link below, and step 1, which says "running master database" 2. Backups are faster then exports (which generates new files) https://cloud.google.com/architecture/migrating-postgresql-to-gcp
upvoted 2 times
...
pico
9 months ago
B This approach minimizes downtime by exporting the database while it's offline, transferring it to Google Cloud Storage, and then restoring it into the new Google Cloud primary server. It's a straightforward and efficient method to migrate your PostgreSQL database. The other options involve additional steps that are not necessary or may introduce unnecessary complexities and potential issues during the migration process. For C and D: The major issue with this option is the additional steps involving creating a recovery.conf file, stopping the source database, transferring write-ahead logs, and syncing with the running primary server. These steps are overly complex and can introduce unnecessary risks and potential complications during the migration process.
upvoted 2 times
...
abdenago
11 months, 1 week ago
Selected Answer: C
https://cloud.google.com/architecture/migrating-postgresql-to-gcp
upvoted 1 times
...
dynamic_dba
1 year, 1 month ago
C. Full exports are not possible offline. Eliminate A and B. Migrating to GCE means you can't use the Database Migration Service. Note, Datastream CDC only supports MySQL and Oracle. To seed the PostgreSQL instance in GCE, a backup is needed created using pg_basebackup. An export won't cut it. That eliminates D and leaves C. Those 9 steps actually make sense.
upvoted 3 times
...
AnilKr
1 year, 1 month ago
C, Its to take full backup not full export in this case.
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel