Google Cloud Digital LeaderDigital transformation with Google CloudEasy
A rapidly growing e-commerce company is migrating its customer database from an on-premises relational database to Google Cloud. They require a fully managed, highly available, and scalable relational database service that is compatible with their existing MySQL applications. Which Google Cloud service meets these requirements?
- ABigtable.
- BFirestore.
- CCloud SQL.
- DCloud Spanner.
Show answer & explanationAnswer & explanation
Correct answer: C. Cloud SQL.
Cloud SQL is a fully managed relational database service that supports MySQL, PostgreSQL, and SQL Server, making it the perfect fit for a company needing a scalable, highly available, and MySQL-compatible solution.
Why the other options are wrong
- A. Bigtable is a NoSQL wide-column database, not suitable for relational MySQL compatibility.
- B. Firestore is a NoSQL document database, not compatible with existing relational (MySQL) applications.
- D. Cloud Spanner is a globally distributed relational database for massive scale, but often overkill and not a direct MySQL drop-in replacement.
Cloud SQL
A fully managed relational database service that allows you to set up, maintain, manage, and administer your relational databases on Google Cloud.
- Supports MySQL, PostgreSQL, and SQL Server.
- Offers high availability, replication, and automatic backups.
- Simplifies database administration and scaling.
- Ideal for traditional relational workloads.
Memory trick: Cloud SQL: The managed SQL 'school' for your databases.