Google Professional Data Engineer Question 31
Single answerGoogle Cloud PlatformYou are designing a data storage system for a financial transaction application on Google Cloud. The application processes millions of transactions daily and requires strict adherence to ACID properties to ensure data integrity. However, during high traffic periods, there are concerns about system availability. Which storage solution should you choose to meet the requirements of ACID compliance while balancing availability?
- A
Cloud Spanner
- B
Cloud Bigtable
- C
Cloud SQL
- D
Google Cloud Storage
Show answer and explanation
Correct answer: A
Explanation
For a financial transaction application requiring strict ACID compliance and high availability, Cloud Spanner is the best choice. It combines horizontal scalability, strong consistency, and high availability, ensuring data integrity and reliability even during high traffic periods. Other options either lack ACID compliance or are not designed for handling high-throughput transactional workloads efficiently.
- A. Correct.
Cloud Spanner is a globally distributed, horizontally scalable database that provides strong consistency and adheres to ACID properties, making it ideal for applications requiring data integrity. It also maintains high availability, even during traffic spikes.
- B. Incorrect.
Cloud Bigtable is a NoSQL database optimized for high-throughput and low-latency workloads. However, it does not natively support ACID properties, making it unsuitable for transactional systems requiring strict data integrity.
- C. Incorrect.
Cloud SQL supports ACID compliance as a relational database, but its vertical scaling limitations may affect availability and performance during high traffic periods, making it less suitable for a system with millions of daily transactions.
- D. Incorrect.
Google Cloud Storage is an object storage service designed for scalability and durability but does not support ACID properties. It is not appropriate for transactional systems requiring strict data integrity.