Google Exam Professional Cloud Database Engineer Topic 13 Question 27 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 27
Topic #: 13

[All Professional Cloud Database Engineer Questions]

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?

APerform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

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.

Show Suggested Answer

Suggested Answer: D

PgBouncer maintains a pool for connections for each database and user combination. PgBouncer either creates a new database connection for a client or reuses an existing connection for the same user and database. + PgBouncer is a simple PostgreSQL connection pool that allows for several thousand connections at a time. Using Kubernetes Engine to run a Helm Chart w/ PgBouncer based on the great article from futuretech-industries, we were able to set up an easily deployable system to get the most out of our CloudSQL DBs without breaking the bank. https://medium.com/google-cloud/increasing-cloud-sql-postgresql-max-connections-w-pgbouncer-kubernetes-engine-49b0b2894820#:~:text=That%20is%20where,breaking%20the%20bank.

by Lemuel at Mar 07, 2024, 01:15 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Rikki

7 months ago

That's true, but I still prefer the simplicity of option C.

upvoted 0 times

...

Glennis

7 months ago

But wouldn't creating a read replica on Cloud SQL as mentioned in option B also reduce downtime?

upvoted 0 times

...

Werner

7 months ago

I think option D with PgBouncer is actually the most efficient method.

upvoted 0 times

...

Rikki

7 months ago

I disagree, I believe option C using Database Migration Service is the way to go.

upvoted 0 times

...

Glennis

7 months ago

I think option A is the best choice for minimum downtime.

upvoted 0 times

...

Annelle

8 months ago

Ooh, good point. Maybe we should just hire a skywriter to announce the migration. That would really minimize the downtime, don't you think?

upvoted 0 times

...

Loise

8 months ago

What about the hot standby on Compute Engine? That's an interesting option. I wonder how it compares to the Database Migration Service in terms of complexity and reliability.

upvoted 0 times

Leonora

8 months ago

What about the hot standby on Compute Engine? That's an interesting option. I wonder how it compares to the Database Migration Service in terms of complexity and reliability.

upvoted 0 times

...

Mireya

8 months ago

D) Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

upvoted 0 times

...

Oretha

8 months ago

A) Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

upvoted 0 times

...

Micah

8 months ago

Haha, true, but then we'd have to manage the whole process ourselves. Not exactly the 'minimum downtime' part of the requirement, am I right?

upvoted 0 times

...

Celestina

8 months ago

This is a tricky question. I'm not sure if I should go with the full backup and incremental approach or the Database Migration Service. Both seem to have their pros and cons.

upvoted 0 times

...