Answer-first summary for fast verification
Answer: Cloud SQL
**A (BigQuery)** is incorrect because BigQuery is designed for analytical queries on large datasets, not for transactional applications requiring strong consistency and ACID guarantees. **B (Firestore)** is incorrect as it's a NoSQL document database suited for real-time data synchronization and mobile apps, lacking the transactional support and ACID guarantees of relational databases. **C (Cloud SQL)** is correct because it offers managed PostgreSQL services, ensuring strong consistency, fast queries, and ACID guarantees for multi-table transactions, making it ideal for migrating the application with minimal code changes. **D (Bigtable)** is incorrect due to its NoSQL nature, which may not meet the strong consistency and ACID requirements for transactional applications. [Learn more about Cloud SQL](https://cloud.google.com/sql).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company operates an internal portal for reimbursements, exclusively used by employees at a single location. The initial version of this application utilizes PostgreSQL, demanding strong consistency, rapid queries, and ACID guarantees for multi-table transactional updates to function correctly. Which Google Cloud service would allow you to migrate this application to Google Cloud with minimal code changes?
A
BigQuery
B
Firestore
C
Cloud SQL
D
Bigtable
No comments yet.