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

Google Professional Cloud Database Engineer Exam - Topic 14 Question 71 Discussion

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?
C) Use Cloud SQL for PostgreSQL with cross-region replicas.
A) Use Bigtable with multi-region clusters.
B) Use Memorystore for Redis with multi-zones within a region.
D) Use Cloud Spanner with multi-region configuration.

Google Professional Cloud Database Engineer Exam - Topic 14 Question 71 Discussion

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

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

0/2000 characters
Quiana
4 days ago
Definitely going with Cloud SQL for the cross-region replicas.
upvoted 0 times
...
Maynard
9 days ago
Surprised that Bigtable is even an option here!
upvoted 0 times
...
Carlota
14 days ago
I think Cloud Spanner is overkill for this use case.
upvoted 0 times
...
Freeman
19 days ago
Cloud SQL for PostgreSQL is a solid choice for SQL compliance.
upvoted 0 times
...
Adell
24 days ago
Totally agree, cross-region replicas are a smart choice!
upvoted 0 times
...
Celestine
29 days ago
Wait, why not just use a simple SQLite for this?
upvoted 0 times
...
Stephaine
1 month ago
Bigtable isn't SQL-compliant, so that's a no-go.
upvoted 0 times
...
Olive
1 month ago
I think Cloud Spanner is overkill for this.
upvoted 0 times
...
Wilson
1 month ago
Cloud SQL for PostgreSQL sounds solid for read-only.
upvoted 0 times
...
Markus
2 months ago
I keep mixing up the options, but I think multi-region support is important for global applications, which makes me lean towards Cloud SQL or Spanner.
upvoted 0 times
...
Gail
2 months ago
I think we had a practice question about batch jobs and database updates, and Cloud SQL seemed to fit well with that.
upvoted 0 times
...
Teresita
2 months ago
I'm not entirely sure, but I feel like Cloud Spanner might be overkill for a read-only application.
upvoted 0 times
...
Micah
4 months ago
I remember we discussed SQL-compliant databases in class, and I think PostgreSQL is a solid choice for this scenario.
upvoted 0 times
...

Save Cancel