Google Cloud Associate Cloud Engineer — Question 282

You need to migrate multiple PostgreSQL databases from your on-premises data center to Google Cloud. You want to significantly improve the performance of your databases while minimizing changes to your data schema and application code. You expect to exceed 150 TB of data per geographical region. You want to follow Google-recommended practices and minimize your operational costs. What should you do?

Answer options

• A. Migrate your data to AlloyDB.
• B. Migrate your data to Spanner.
• C. Migrate your data to Firebase.
• D. Migrate your data to Bigtable.

Correct answer: A

Explanation

The correct choice is A, as AlloyDB is specifically designed to support PostgreSQL workloads and offers optimal performance while maintaining compatibility with existing applications and schemas. Options B (Spanner), C (Firebase), and D (Bigtable) are not tailored for PostgreSQL and may require significant changes to the data structure or application logic, making them less suitable for this scenario.