You work for a large bank that operates in locations throughout North America. You are setting up a data storage system that will handle bank account transactions. You require ACID compliance and…

The correct answer is B. Store transaction in Cloud Spanner. Use locking read-write transactions. Explanation/Reference: As the documentation primarily says ACID compliance for Spanner, not Cloud SQL. https://cloud.google.com/blog/topics/developers-practitioners/your-google-cloud-database-options-explained Also, spanner supports read-write transactions for use cases, as…

Submitted by yaw92· Mar 30, 2026Designing data processing systems

Question

You work for a large bank that operates in locations throughout North America. You are setting up a data storage system that will handle bank account transactions. You require ACID compliance and the ability to access data with SQL. Which solution is appropriate?

Options

AStore transaction data in Cloud Spanner. Enable stale reads to reduce latency.
BStore transaction in Cloud Spanner. Use locking read-write transactions.
CStore transaction data in BigQuery. Disabled the query cache to ensure consistency.
DStore transaction data in Cloud SQL. Use a federated query BigQuery for analysis.

How the community answered

(50 responses)

A
4% (2)
B
72% (36)
C
16% (8)
D
8% (4)

Explanation

Explanation/Reference: As the documentation primarily says ACID compliance for Spanner, not Cloud SQL. https://cloud.google.com/blog/topics/developers-practitioners/your-google-cloud-database-options-explained Also, spanner supports read-write transactions for use cases, as handling bank transactions: https://cloud.google.com/spanner/docs/transactions#read-write_transactions

Topics

#Cloud Spanner#ACID compliance#locking transactions#relational databases

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-DATA-ENGINEER Practice