Google Professional Data Engineer Question 32
Single answerGoogle Cloud PlatformYour team is designing a financial application on Google Cloud that processes transaction data. The application must ensure that all transactions are processed exactly once, maintain data consistency during failures, and support high availability. Which storage solution should you choose to meet these requirements?
- A
Cloud Spanner
- B
Cloud Bigtable
- C
Cloud Storage
- D
Cloud SQL
Show answer and explanation
Correct answer: A
Explanation
The financial application requires a solution that ensures data consistency, durability, and high availability. Cloud Spanner is the best choice as it is a globally distributed, highly available relational database that offers full ACID compliance, making it ideal for transactional systems like financial applications. Other options either lack ACID compliance or do not meet the high availability requirements.
- A. Correct.
Cloud Spanner is a globally distributed database that supports ACID compliance and provides high availability. It is ideal for transactional workloads where consistency and durability are critical.
- B. Incorrect.
Cloud Bigtable is a NoSQL database optimized for analytical workloads and high throughput but does not natively support ACID transactions, making it unsuitable for this scenario.
- C. Incorrect.
Cloud Storage is an object store designed for unstructured data storage and does not support ACID transactions, thus not meeting the requirements of transactional consistency.
- D. Incorrect.
Cloud SQL provides ACID compliance but is not designed for high availability in globally distributed systems like Cloud Spanner, making it less suitable for this use case.