Professional Cloud ArchitectDesign and plan a cloud solution architectureMedium
A retail company is migrating its inventory management system to Google Cloud. The system relies on a PostgreSQL database that is critical for daily operations and has strict uptime requirements. They need a fully managed database service that offers high availability, automatic backups, and simplified patching, allowing their team to focus on application development rather than database administration. Which Google Cloud service should they choose?
- ABigQuery
- BCompute Engine with self-managed PostgreSQL
- CCloud Spanner
- DCloud SQL for PostgreSQL
Show answer & explanationAnswer & explanation
Correct answer: D. Cloud SQL for PostgreSQL
Cloud SQL for PostgreSQL is a fully managed relational database service that provides high availability, automatic backups, and simplified patching, significantly reducing operational overhead for critical transactional databases.
Why the other options are wrong
- A. BigQuery is a data warehouse for analytics, not a transactional relational database for operational systems like an inventory management system.
- B. Self-managing PostgreSQL on Compute Engine requires significant administrative effort for high availability, backups, and patching, which goes against the 'simplified patching' and 'focus on application development' requirements.
- C. Cloud Spanner is a globally distributed relational database for petabyte-scale transactional workloads, which is overkill and more expensive for a regional inventory system that can be handled by Cloud SQL.
Cloud SQL
A fully managed relational database service for MySQL, PostgreSQL, and SQL Server, offering high availability, automatic backups, replication, and simplified patching.
- Fully managed relational database
- Supports MySQL, PostgreSQL, SQL Server
- High availability and automatic backups
Memory trick: Cloud SQL takes care of your SQL database so you don't have to.