
Answer-first summary for fast verification
Answer: Cloud SQL
The best choice for this application is Cloud SQL for PostgreSQL. It offers the required strong consistency, fast queries, and ACID guarantees for multi-table transactional updates. Additionally, it allows deployment to the cloud with minimal code changes as it is already implemented in PostgreSQL. Unlike Cloud Spanner, which is designed for larger, globally distributed databases, Cloud SQL is suitable for applications used in a single physical location.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company has developed an internal application to handle transactional orders, intended solely for employees situated in a single physical location. This application demands strong consistency, rapid query performance, and ACID compliance for updates that span multiple tables. The initial version of this application is built using PostgreSQL, and there is a requirement to migrate it to a cloud environment with minimal modifications to the existing code. Which cloud database solution would be the most suitable for this application?
A
BigQuery
B
Cloud SQL
C
Cloud Spanner
D
Cloud Datastore
No comments yet.