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 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 Hide Answer
Suggested Answer: C 🗳️
by pk349 at Dec. 25, 2022, 12:03 a.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
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 5 months, 1 week 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
5 months, 1 week ago
Plus Cloud Spanner offers Postgres - opensource version. So it checks that box too.
upvoted 2 times
...
dija123
5 months 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
...
...
Nirca
1 year, 7 months ago
Selected Answer: C
C. PostgreSQL is a real open source RDBMS
upvoted 2 times
...
chelbsik
1 year, 10 months ago
Selected Answer: C
I'll go for C
upvoted 3 times
...
pk349
1 year, 10 months ago
C: Use Cloud SQL for PostgreSQL *** with cross-region replicas.
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