Google Cloud Professional Cloud Database Engineer — Question 53

You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because Cloud SQL for PostgreSQL provides a managed service that simplifies the migration process and maintains compatibility with PostgreSQL, making it cost-effective for light traffic applications. Option A is incorrect as Firestore is a NoSQL database that would require significant changes to the application's data model. Option C is not suitable due to Cloud Spanner's higher cost and complexity, which are unnecessary for a low-traffic relational database. Option D, while feasible, would involve more operational overhead and management compared to the managed service offered by Cloud SQL.