Answer-first summary for fast verification
Answer: Migrate your PostgreSQL database to Cloud SQL for PostgreSQL.
The correct answer is D. The choice to migrate your PostgreSQL database to Cloud SQL for PostgreSQL aligns well with the goal of minimizing cost and complexity. Cloud SQL is managed by Google Cloud, which simplifies database management and operations. Additionally, Cloud SQL for PostgreSQL supports extensions and tools that are familiar to PostgreSQL users, making the migration process smoother. Furthermore, for analytics, federated queries over Cloud SQL (PostgreSQL) can be applied, thus optimizing the solution for both transactional and analytical needs while keeping costs low.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To modernize your existing data environment, you aim to run both transactional workloads and support analytical needs using a single database solution. At present, your transactional data is stored on-premises in a PostgreSQL database. Your objective is to migrate this database to Google Cloud in a way that requires no change in the database management system and keeps costs and complexity to a minimum. What is the best approach to achieve this migration?
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.
No comments yet.