Associate Cloud EngineerDemo

By Google · Question Mode

QuestionQ18

Planning and configuring a cloud solution

Your company intends to migrate its on-premises PostgreSQL database to Google Cloud. The workloads are demanding and require fast transactional and analytical performance. You need to choose a fully managed Google Cloud database service. The solution must also be capable of synchronous replication and storage-layer optimization. What should you do?

  • 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.
Explanation

AlloyDB for PostgreSQL is a fully managed, PostgreSQL-compatible service built for high-performance transactional and analytical workloads. Its storage layer is separated from compute, optimized for database processing, and synchronously replicated across zones for high availability. Database Migration Service supports migrations from PostgreSQL to AlloyDB.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!