
Answer-first summary for fast verification
Answer: Cloud SQL
The correct answer is C. Cloud SQL is the most appropriate database for this application because it supports PostgreSQL, offering strong consistency, fast queries, and ACID guarantees for multi-table transactional updates. Deploying your existing PostgreSQL-based application to Cloud SQL requires minimal code changes, making it the best fit for your requirements.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company operates an internal application solely for managing transactional orders, accessible exclusively by employees at a single physical location. This application necessitates strong consistency, rapid query responses, and ACID (Atomicity, Consistency, Isolation, Durability) compliance for handling multi-table transactional updates. Initially, the application was developed using PostgreSQL, and you now aim to migrate it to the cloud with minimal modifications to the existing codebase. Which cloud database solution would be the most suitable for this application?
A
Bigtable
B
BigQuery
C
Cloud SQL
D
Firestore
No comments yet.