Google Cloud Professional Data Engineer — Question 215

You currently have transactional data stored on-premises in a PostgreSQL database. To modernize your data environment, you want to run transactional workloads and support analytics needs with a single database. You need to move to Google Cloud without changing database management systems, and minimize cost and complexity. What should you do?

Answer options

• A. Migrate and modernize your database with Cloud Spanner.
• B. Migrate your workloads to AlloyDB for PostgreSQL.
• C. Migrate to BigQuery to optimize analytics.
• D. Migrate your PostgreSQL database to Cloud SQL for PostgreSQL.

Correct answer: B

Explanation

The correct answer is B because AlloyDB for PostgreSQL is designed to support both transactional and analytical workloads while maintaining compatibility with PostgreSQL, making it a suitable choice for modernization. Options A and D involve using Cloud Spanner and Cloud SQL, respectively, which may not meet the requirement of minimizing complexity without changing the database management system. Option C, while useful for analytics, does not support transactional workloads as needed.