Exam Professional Cloud Database Engineer topic 1 question 66 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 66
Topic #: 1

[All Professional Cloud Database Engineer Questions]

You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?

A. Use Bigtable with multi-region clusters.
B. Use Memorystore for Redis with multi-zones within a region.
C. Use Cloud SQL for PostgreSQL with cross-region replicas.
D. Use Cloud Spanner with multi-region configuration.

Show Suggested Answer

Suggested Answer: C 🗳️

by pk349 at Dec. 25, 2022, 12:03 a.m.

Comments

Submit Cancel

dynamic_dba

Highly Voted 1 year, 9 months ago

C. Bigtable doesn’t support SQL. Eliminate A. Even if Memorystore could scale, B says single region. Eliminate B. Cloud Spanner supports Google Standard SQL and PostgreSQL dialects. That’s not the same thing as a natively open source database. Eliminate D. That leaves C.

upvoted 5 times

...

gcp_k

Most Recent 6 months, 3 weeks ago

D. It says global application, open source and sql compliant, why not Cloud Spanner? Cloud SQL for PostgreSQL is the best if the question did not mention "global application" .. With Cloud SQL for PostgreSQL, you cannot reach the global audience. the latency will be terrible.

upvoted 3 times

gcp_k

6 months, 3 weeks ago

Plus Cloud Spanner offers Postgres - opensource version. So it checks that box too.

upvoted 2 times

...

dija123

6 months, 3 weeks ago

According to gemini: While Cloud Spanner is a powerful globally distributed database, it might be overkill for a read-only application with nightly updates. It's also generally more complex to manage compared to Cloud SQL.

upvoted 2 times

...