Answer-first summary for fast verification
Answer: Migrate the existing database to Cloud SQL for PostgreSQL.
Given the scenario, the best option is to migrate the existing PostgreSQL database to Cloud SQL for PostgreSQL. This choice is optimal because Cloud SQL is a fully managed database service that minimizes the operational overhead, aligning with the goal to reduce costs and migration effort. It supports PostgreSQL, ensuring compatibility with the existing relational data and application. Firestore is not suitable as it is a NoSQL database, which would require significant changes to the application's data model. Cloud Spanner, while powerful, is designed for large-scale, globally distributed applications and would be overkill for light traffic, leading to unnecessary costs. Running PostgreSQL on Compute Engine would not reduce operational overhead as it still requires management by the team, contrary to the goal of minimizing effort and costs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the recommended approach for selecting a new database backend for an existing application with a lightly trafficked relational dataset, currently running PostgreSQL on an on-premises VM managed by a DBA and operations team, while minimizing both costs and migration effort?
A
Migrate the existing database to Firestore.
B
Migrate the existing database to Cloud SQL for PostgreSQL.
C
Migrate the existing database to Cloud Spanner.
D
Migrate the existing database to PostgreSQL running on Compute Engine.