Google Cloud Digital LeaderGeneral knowledge of Google CloudEasy
A company is planning to migrate its on-premises relational database to Google Cloud. They require a fully managed service that offers high availability, automated patching, scaling, and backups, compatible with PostgreSQL. Which Google Cloud product should they choose?
- ACloud SQL
- BCloud Spanner
- CCompute Engine
- DBigQuery
Show answer & explanationAnswer & explanation
Correct answer: A. Cloud SQL
Cloud SQL is a fully managed relational database service that supports PostgreSQL, MySQL, and SQL Server. It provides automated patching, backups, replication, and scaling, meeting all the specified requirements.
Why the other options are wrong
- B. Cloud Spanner is a globally distributed, horizontally scalable relational database, not typically used for simple migrations of existing relational databases unless global scale is a specific, advanced requirement.
- C. Compute Engine provides IaaS VMs, requiring manual database management.
- D. BigQuery is a serverless data warehouse, not a managed relational database for transactional workloads.
Google Cloud SQL
Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server, handling patching, backups, and scaling.
- Supports MySQL, PostgreSQL, and SQL Server.
- Automates database administration tasks.
- Offers high availability and disaster recovery options.
Memory trick: Databases in the Cloud: SQL for Relational, Spanner for Global, BigQuery for Warehousing.