Google Cloud Professional Cloud Database Engineer — Question 165

You are migrating an on-premises online transactional process (OLTP) PostgreSQL database to Google Cloud. You want to reduce the administrative overhead on database maintenance activities, such as vacuum and memory tuning. You are also planning to introduce analytic use cases in this database. You need the migration to have minimal schema and application changes. What should you do?

Answer options

• A. Use Spanner with PGAdapter.
• B. Use Cloud SQL for PostgreSQL.
• C. Use AlloyDB for PostgreSQL.
• D. Deploy a self-managed PostgreSQL database on Compute Engine.

Correct answer: C

Explanation

The correct answer is C, as AlloyDB for PostgreSQL is designed to handle both transactional and analytical workloads while reducing management overhead. Options A and B are less suitable because Spanner may require more significant schema changes and Cloud SQL does not optimize for analytical workloads as effectively as AlloyDB. Option D involves a self-managed database, which increases administrative tasks, contrary to the goal of minimizing maintenance.