Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam

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

Suggested Answer: C 🗳️

by AnilKr at March 24, 2023, 5:25 a.m.

Comments

Submit Cancel

dynamic_dba

Highly Voted 1 year, 9 months 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 5 times

...

887ad17

Most Recent 5 months, 2 weeks ago

Selected Answer: C

C fullbackup = basebackup + wals

upvoted 1 times

...

dija123

7 months, 3 weeks ago

Selected Answer: C

Agree with C, As taking backup is faster than the export.

upvoted 1 times

...

Pime13

8 months, 2 weeks ago

c: https://cloud.google.com/architecture/migrating-postgresql-to-gcp

upvoted 1 times

...

njda

1 year, 4 months 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

1 year, 5 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

1 year, 7 months ago

Selected Answer: C

https://cloud.google.com/architecture/migrating-postgresql-to-gcp

upvoted 1 times

...

AnilKr

1 year, 9 months ago

C, Its to take full backup not full export in this case.

upvoted 1 times

...