Google Cloud Associate Cloud Engineer — Question 298

Your company plans to migrate its on-premises PostgreSQL database to Google Cloud. The workloads are demanding, requiring fast transactional and analytical performance. You need to select a fully managed database service on Google Cloud. Your solution must also be able to synchronously replicate and optimize the storage layer. What should you do?

Answer options

• A. Migrate the database to Cloud SQL for PostgreSQL by using Database Migration Service.
• B. Use the psql client installed on a Compute Engine instance. Connect to the Cloud SQL instance to perform the database migration.
• C. Migrate the database to AlloyDB for PostgreSQL by using Database Migration Service.
• D. Create a Compute Engine instance. Install and configure PostgreSQL on the instance, and migrate the database.

Correct answer: C

Explanation

The correct answer is C because AlloyDB for PostgreSQL is designed to handle demanding workloads with features like synchronous replication and optimized storage. Option A, while a valid service, does not specifically meet the high-performance requirements as well as AlloyDB does. Options B and D involve more manual setups, which do not provide the fully managed service needed for optimal performance.