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 115 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 115
Topic #: 1
[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?

  • A. Migrate the existing database to Firestore.
  • B. Migrate the existing database to Cloud SQL for PostgreSQL.
  • C. Migrate the existing database to Cloud Spanner.
  • D. Migrate the existing database to PostgreSQL running on Compute Engine.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by pk349 at Dec. 24, 2022, 10:23 p.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
B. Firestore is a NoSQL database. Eliminate A. You could migrate to Spanner leveraging the PostgreSQL dialect, but costs need to be minimized so that wouldn’t be the cheapest option. Especially since the load doesn’t justify Spanner. Again, you could migrate like-for-like to a GCE VM, but that defeats minimizing the migration effort. The cheapest and easiest way to migrate would be Database Migration Service to Cloud SQL for PostgreSQL.
upvoted 6 times
ArtistS
10 months, 2 weeks ago
I agree with u. The answer is B
upvoted 1 times
...
...
dija123
Most Recent 5 months ago
Selected Answer: B
Totally B
upvoted 1 times
...
chelbsik
1 year, 10 months ago
Selected Answer: B
Migrate to CloudSQL
upvoted 2 times
...
pk349
1 year, 10 months ago
B: Migrate the existing database to Cloud SQL for PostgreSQL.
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