Answer-first summary for fast verification
Answer: Store transaction in Cloud Spanner. Use locking read-write transactions.
The correct answer is B. Cloud Spanner is designed for global scalability and strong consistency, making it ideal for a large bank's transaction system that requires ACID compliance and SQL access. Locking read-write transactions ensure data integrity and prevent conflicts. While Cloud SQL also provides ACID compliance, it does not scale horizontally as efficiently as Cloud Spanner for large volumes. BigQuery is not a suitable option because it does not natively support ACID transactions or SQL writes, which are necessary for banking transactions.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
As a data engineer for a large bank operating across North America, you are tasked with establishing a data storage system specifically designed to handle critical bank account transactions. Given the nature of these transactions, it is imperative that the storage solution adheres to ACID (Atomicity, Consistency, Isolation, Durability) principles to ensure data reliability and consistency. Additionally, the solution must support SQL for data querying and management. Which data storage solution would be most suitable for this requirement?
A
Store transaction data in Cloud Spanner. Enable stale reads to reduce latency.
B
Store transaction in Cloud Spanner. Use locking read-write transactions.
C
Store transaction data in BigQuery. Disable the query cache to ensure consistency.
D
Store transaction data in Cloud SQL. Use a federated query BigQuery for analysis.