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 11 Question 17 Discussion

You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
B) Migrate the existing database to Cloud SQL for PostgreSQL.
A) Migrate the existing database to Firestore.
C) Migrate the existing database to Cloud Spanner.
D) Migrate the existing database to PostgreSQL running on Compute Engine.

Google Professional Cloud Database Engineer Exam - Topic 11 Question 17 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 17
Topic #: 11
[All Professional Cloud Database Engineer Questions]

You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Arminda at Mar 30, 2023, 03:25 PM

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
Casie
9 months ago
Wait, why not just keep it on-premises?
upvoted 0 times
...
Desirae
9 months ago
Sticking with PostgreSQL on Compute Engine sounds safe.
upvoted 0 times
...
Shantell
9 months ago
Cloud Spanner? Isn't that overkill for light traffic?
upvoted 0 times
...
Lindsay
9 months ago
I disagree, Firestore could be more cost-effective!
upvoted 0 times
...
Burma
9 months ago
Cloud SQL for PostgreSQL seems like the best fit.
upvoted 0 times
...
Erinn
9 months ago
I think running PostgreSQL on Compute Engine might be similar to what we have now, but I'm not sure if it really minimizes costs.
upvoted 0 times
...
Mirta
9 months ago
I'm a bit unsure about Cloud Spanner; it seems like overkill for light traffic and could increase costs.
upvoted 0 times
...
Tiffiny
9 months ago
I feel like Cloud SQL for PostgreSQL could be a good option since it keeps the same database type and might reduce migration effort.
upvoted 0 times
...
Farrah
10 months ago
I remember we discussed that Firestore is more suited for NoSQL, so I think that's not the best choice here.
upvoted 0 times
...
Thaddeus
10 months ago
Hmm, I'm a bit confused here. The question mentions a take-over bid, but I'm not sure how that affects the accountants' liability. I'll need to re-read the details closely.
upvoted 0 times
...
Ashlyn
10 months ago
Hmm, I'm a bit unsure about the proper journal entries for this type of transaction. I'll need to review the accounting standards on sale and leaseback agreements to make sure I understand the requirements.
upvoted 0 times
...
Donte
10 months ago
This is a tricky one. There are a few different places the next number series could be set up, so I'll need to carefully read through each option to figure out which one is the right first step.
upvoted 0 times
...
France
10 months ago
Okay, I've got this. For a data inventory, I need to collect information on the data location and the data policies. That will give me a good understanding of where the data is stored and how it's supposed to be managed.
upvoted 0 times
...

Save Cancel