Answer-first summary for fast verification
Answer: Cloud SQL
**Correct Answer: B (Cloud SQL)** - **A (BigQuery)** is not suitable because it is designed for analytical queries on large datasets and does not support strong consistency or ACID transactions. - **B (Cloud SQL)** is the correct choice as it supports PostgreSQL, allowing for minimal code changes during migration. It offers strong consistency and ACID transactions, aligning with the application's requirements. - **C (Cloud Spanner)** supports ACID transactions and strong consistency but does not support PostgreSQL syntax, requiring significant code changes. It is also more suited for globally distributed applications, which is not the case here. - **D (Cloud Datastore)** is a NoSQL database that does not provide strong consistency or ACID transactions, making it unsuitable for the application's needs. For more information, refer to the following links: - [Cloud SQL for PostgreSQL](https://cloud.google.com/sql/docs/postgres) - [Cloud Datastore](https://cloud.google.com/datastore) - [BigQuery Data Warehouse](https://cloud.google.com/architecture/bigquery-data-warehouse)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Your company is planning to migrate an internal performance tracking application to Google Cloud Platform (GCP). The application is currently used by employees located in a single region and relies on PostgreSQL, with a strong dependency on strong consistency and ACID transactions for multi-table write operations. Which GCP database service would be the most suitable for this application?
A
BigQuery
B
Cloud SQL
C
Cloud Spanner
D
Cloud Datastore