Google Cloud Associate Cloud Engineer — Question 169

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

• A. BigQuery
• B. Cloud SQL
• C. Cloud Spanner
• D. Cloud Datastore

Correct answer: B

Explanation

The correct answer is Cloud SQL because it provides a managed PostgreSQL service, allowing for minimal code changes when migrating. BigQuery is not suitable as it is designed for analytics rather than transactional workloads. Cloud Spanner offers horizontal scaling and global distribution, which is unnecessary for a single location application. Cloud Datastore is a NoSQL database that does not provide the ACID guarantees required for multi-table transactions.