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

Suggested Answer: B 🗳️

by pk349 at Dec. 24, 2022, 10:23 p.m.

Comments

Submit Cancel

dynamic_dba

Highly Voted 1 year, 10 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