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
10 months ago
Wait, why not just keep it on-premises?
upvoted 0 times
...
Desirae
10 months ago
Sticking with PostgreSQL on Compute Engine sounds safe.
upvoted 0 times
...
Shantell
10 months ago
Cloud Spanner? Isn't that overkill for light traffic?
upvoted 0 times
...
Lindsay
11 months ago
I disagree, Firestore could be more cost-effective!
upvoted 0 times
...
Burma
11 months ago
Cloud SQL for PostgreSQL seems like the best fit.
upvoted 0 times
...
Erinn
11 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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