PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #38
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…
The correct answer is C. Use Cloud SQL for PostgreSQL with cross-region replicas. The key constraints are: open source, SQL-compliant, read-heavy global access, and centralized nightly batch writes. Cloud SQL for PostgreSQL satisfies open source and SQL compliance. Cross-region read replicas distribute read traffic globally for low-latency access worldwide…
Question
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?
Options
- AUse Bigtable with multi-region clusters.
- BUse Memorystore for Redis with multi-zones within a region.
- CUse Cloud SQL for PostgreSQL with cross-region replicas.
- DUse Cloud Spanner with multi-region configuration.
How the community answered
(53 responses)- A11% (6)
- B4% (2)
- C79% (42)
- D6% (3)
Explanation
The key constraints are: open source, SQL-compliant, read-heavy global access, and centralized nightly batch writes. Cloud SQL for PostgreSQL satisfies open source and SQL compliance. Cross-region read replicas distribute read traffic globally for low-latency access worldwide, while the centralized primary instance handles the nightly batch writes. Option A (Bigtable) is not open source SQL - it's a proprietary wide-column NoSQL store. Option B (Memorystore for Redis) is an in-memory key-value store, not SQL-compliant. Option D (Cloud Spanner) is not open source - it is a proprietary Google database, even though it uses SQL syntax.
Topics
Community Discussion
No community discussion yet for this question.