ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to 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 Hide Answer
Suggested Answer: C 🗳️
by AnilKr at March 24, 2023, 5:25 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
dynamic_dba
Highly Voted 1 year, 7 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 3 months ago
Selected Answer: C
C fullbackup = basebackup + wals
upvoted 1 times
...
dija123
5 months ago
Selected Answer: C
Agree with C, As taking backup is faster than the export.
upvoted 1 times
...
Pime13
5 months, 3 weeks ago
c: https://cloud.google.com/architecture/migrating-postgresql-to-gcp
upvoted 1 times
...
njda
1 year, 1 month 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, 2 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, 4 months ago
Selected Answer: C
https://cloud.google.com/architecture/migrating-postgresql-to-gcp
upvoted 1 times
...
AnilKr
1 year, 7 months ago
C, Its to take full backup not full export in this case.
upvoted 1 times
...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago