Google Cloud Associate Cloud Engineer — Question 210

Your company has an internal application for managing transactional orders. The application is used exclusively by employees in a single physical location. The application requires strong consistency, fast queries, and ACID guarantees for multi-table transactional updates. The first version of the application is implemented in PostgreSQL, and you want to deploy it to the cloud with minimal code changes. Which database is most appropriate for this application?

Answer options

Correct answer: C

Explanation

Cloud SQL is the ideal choice because it is designed to handle relational databases like PostgreSQL, maintaining strong consistency and supporting ACID transactions. The other options, such as Bigtable, BigQuery, and Firestore, are not relational databases and do not support the same transactional guarantees necessary for the application.