MENU
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?
Suggested Answer: C
Get Premium Professional Cloud Database Engineer Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
24 comments · newest first
VI
Viola
2 days ago
True, but C is simpler for our needs.
SH
Shenika
8 days ago
But D offers scalability. Multi-region is a big plus!
AL
Alecia
13 days ago
I agree, C has great support for read-only queries.
ST
Stefan
18 days ago
I think option C is the best choice. PostgreSQL is reliable.
CA
Camellia
23 days ago
Exactly! C balances performance and ease of use.
LA
Lavonne
28 days ago
I feel like A is not suitable. Bigtable is more for NoSQL.
LU
Luisa
1 month ago
True, but C is simpler for read-only purposes.
ES
Esteban
1 month ago
But D could be better for scalability. Spanner handles large data.
XU
Xuan
1 month ago
I agree, C offers cross-region replicas. Good for global access.
TO
Tomas
2 months ago
I think option C is the best choice. PostgreSQL is reliable.
RO
Rory
2 months ago
Not sure if Memorystore fits the read-only requirement.
QU
Quiana
2 months ago
Definitely going with Cloud SQL for the cross-region replicas.
MA
Maynard
2 months ago
Surprised that Bigtable is even an option here!
CA
Carlota
2 months ago
I think Cloud Spanner is overkill for this use case.
FR
Freeman
2 months ago
Cloud SQL for PostgreSQL is a solid choice for SQL compliance.
AD
Adell
3 months ago
Totally agree, cross-region replicas are a smart choice!
CE
Celestine
3 months ago
Wait, why not just use a simple SQLite for this?
ST
Stephaine
3 months ago
Bigtable isn't SQL-compliant, so that's a no-go.
OL
Olive
3 months ago
I think Cloud Spanner is overkill for this.
WI
Wilson
3 months ago
Cloud SQL for PostgreSQL sounds solid for read-only.
MA
Markus
4 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.
GA
Gail
4 months ago
I think we had a practice question about batch jobs and database updates, and Cloud SQL seemed to fit well with that.
TE
Teresita
4 months ago
I'm not entirely sure, but I feel like Cloud Spanner might be overkill for a read-only application.
MI
Micah
5 months ago
I remember we discussed SQL-compliant databases in class, and I think PostgreSQL is a solid choice for this scenario.