Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Cloud Database Engineer Exam - Topic 13 Question 27 Discussion

You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
D) Use the mysqldump utility and binary logs.
A) Use external server replication.
B) Use Data Migration Service.
C) Use Cloud SQL for MySQL external replica.

Google Professional Cloud Database Engineer Exam - 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 are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Geoffrey
9 months ago
Are we sure B is even relevant here? Seems off.
upvoted 0 times
...
Veronika
9 months ago
Totally agree with C, it's super easy to set up!
upvoted 0 times
...
Lauryn
10 months ago
Wait, isn't D a bit outdated for this use case?
upvoted 0 times
...
Alonso
10 months ago
I think A could work too, but not as efficient.
upvoted 0 times
...
Raelene
10 months ago
C is the best choice for external replicas!
upvoted 0 times
...
Arlene
10 months ago
Using mysqldump and binary logs sounds familiar, but I don't think that's the most efficient way to handle replication in this scenario.
upvoted 0 times
...
Mariko
11 months ago
I feel like the Data Migration Service is more for moving data rather than creating replicas, but I could be wrong.
upvoted 0 times
...
Buddy
11 months ago
I remember practicing a question about external server replication, but I can't recall if it was the right choice for scaling reads.
upvoted 0 times
...
Victor
11 months ago
I think using Cloud SQL for MySQL external replica might be the best option since it simplifies management, but I'm not entirely sure.
upvoted 0 times
...
Gregg
11 months ago
This seems like a classic cloud migration scenario. I'd start by looking at the Cloud SQL external replica option, as that seems like it would integrate well with the Compute Engine infrastructure we're already using.
upvoted 0 times
...
Kasandra
11 months ago
I'm a bit confused by the hybrid configuration mentioned in the question. Does that mean we need to consider on-premises servers as well as the cloud? I'll need to make sure I understand the full context before deciding.
upvoted 0 times
...
Jaleesa
11 months ago
Okay, let's think this through step-by-step. We need to scale reads and offload management, so I'm thinking either the Cloud SQL external replica or the Data Migration Service could be good options.
upvoted 0 times
...
Alease
11 months ago
Hmm, I'm a little unsure about the differences between the options presented. I'll need to review the details of each approach to make sure I understand the tradeoffs.
upvoted 0 times
...
Aron
11 months ago
This looks like a pretty straightforward question about setting up MySQL database replicas on Google Cloud. I think I've got a good handle on the options here.
upvoted 0 times
...
Tamekia
11 months ago
This question seems straightforward. I think the answer is B, "Point of contact."
upvoted 0 times
...
Alva
11 months ago
The transport layer is definitely Layer 4, I remember that from the lectures. B is the answer.
upvoted 0 times
...
Refugia
11 months ago
This question seems straightforward, but I want to make sure I understand the approval limits correctly before selecting my answers.
upvoted 0 times
...
Tamekia
11 months ago
This question kind of reminds me of a similar one about Layer 2 interworking. I feel like nonrouted setups could be an option, but I'm not confident.
upvoted 0 times
...
Teddy
1 year ago
Forget the exam, I'm just here for the free donuts. Oh, wait, this is a virtual test? Nevermind, I'll just go with C then.
upvoted 0 times
Tonette
1 year ago
Don't worry about the exam, just focus on the free donuts!
upvoted 0 times
...
Kina
1 year ago
It's a virtual test, so just go with C for now.
upvoted 0 times
...
Joye
1 year ago
Yeah, Cloud SQL for MySQL external replica is the way to go.
upvoted 0 times
...
Eun
1 year ago
I think C is the best option for creating replicas.
upvoted 0 times
...
...
Nan
1 year ago
I'm voting for Option C! Keeping it in the Google Cloud ecosystem makes the most sense for my hybrid setup.
upvoted 0 times
...
Gianna
1 year ago
Option B with the Data Migration Service could be a good choice, but I'm not sure if it supports the hybrid configuration I'm working with.
upvoted 0 times
Dudley
1 year ago
C) Cloud SQL for MySQL external replica could also be a good choice for scaling reads.
upvoted 0 times
...
Alona
1 year ago
B) I think using Data Migration Service might be the best option for your hybrid configuration.
upvoted 0 times
...
Alpha
1 year ago
A) Use external server replication.
upvoted 0 times
...
...
Benedict
1 year ago
I was thinking along the lines of Option D, but using the mysqldump utility and binary logs might be a bit too manual for my needs.
upvoted 0 times
Darrin
1 year ago
I agree, Option C is a more automated solution that can help scale reads and offload management operations efficiently.
upvoted 0 times
...
Marcos
1 year ago
Option C sounds like a better choice for you. It allows you to create replicas easily without manual intervention.
upvoted 0 times
...
...
Tiera
1 year ago
Option C seems like the way to go. Cloud SQL for MySQL external replica sounds like the perfect solution for my hybrid setup.
upvoted 0 times
Brynn
1 year ago
Great to hear that it worked well for you. I'll definitely give it a try for my MySQL databases on Google Cloud.
upvoted 0 times
...
Page
1 year ago
I've used it before and it worked really well for me. It's a reliable option for creating replicas in a hybrid configuration.
upvoted 0 times
...
Elenora
1 year ago
I agree, using Cloud SQL for MySQL external replica will definitely help scale reads and offload management operations.
upvoted 0 times
...
Malcolm
1 year ago
Option C seems like the way to go. Cloud SQL for MySQL external replica sounds like the perfect solution for my hybrid setup.
upvoted 0 times
...
...
Crista
1 year ago
I prefer using the mysqldump utility and binary logs for creating replicas.
upvoted 0 times
...
Crista
1 year ago
I agree with Julene, Cloud SQL for MySQL external replica is the best option for scaling reads.
upvoted 0 times
...
Julene
1 year ago
I think we should use Cloud SQL for MySQL external replica.
upvoted 0 times
...

Save Cancel