Google Cloud Professional Cloud Database Engineer — Question 100

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because Cloud SQL for PostgreSQL allows for cross-region replicas, which is essential for a global application that requires high availability and read performance. Option A is incorrect as Bigtable is not SQL-compliant, while option B is not suitable for SQL databases. Option D, though it supports multi-region setups, is not an open-source solution.