Explanation:
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.
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.