A company is migrating its on-premises PostgreSQL database to Google Cloud. They need a managed service that is fully compatible with PostgreSQL, offers high availability, and provides automated backups. Which TWO Google Cloud services should they consider?
Cloud SQL is a fully managed relational database service that supports PostgreSQL, providing automated backups, point-in-time recovery, and high availability with synchronous replication across zones. It offers native PostgreSQL compatibility, so applications can migrate without any changes to their SQL or data access layer. With managed maintenance, scaling, and built-in security features like IAM integration and encryption at rest, Cloud SQL is the pragmatic default choice for most PostgreSQL migrations to Google Cloud.
Why this answer
Cloud SQL (A) is correct because it is a fully managed relational database service that supports PostgreSQL with full compatibility, offers high availability through regional configurations with automatic failover, and provides automated backups and point-in-time recovery. AlloyDB (C) is also correct because it is a fully managed PostgreSQL-compatible database service designed for high availability with a multi-node architecture and automated backups, while offering enhanced performance for demanding workloads. Memorystore (B) is incorrect because it is a managed in-memory data store for Redis and Memcached, not a PostgreSQL-compatible relational database.
Filestore (D) is incorrect because it is a managed network file storage service (NFS) for file-based workloads, not a database service. Cloud Bigtable (E) is incorrect because it is a fully managed NoSQL wide-column database, not PostgreSQL-compatible.
Exam trap
GCDL often tests the confusion between Cloud SQL and AlloyDB, where candidates might think AlloyDB is not PostgreSQL-compatible or that Cloud SQL is not fully managed, when in fact both are valid options for PostgreSQL migration.