Design storage for bank account transactions requiring ACID guarantees and SQL access. Which solution is appropriate?
Choose an answer
Tap an option to check your answer.
Correct answer: Store transaction data in Cloud Spanner and use locking read-write transactions..
Why this is the answer
Cloud Spanner is a globally distributed, strongly consistent, relational database service that provides ACID guarantees and SQL access, making it ideal for financial transactions. Using locking read-write transactions ensures strong consistency and isolation, preventing data anomalies. Stale reads in Spanner can reduce latency but compromise strong consistency, which is critical for bank transactions. BigQuery is an analytical data warehouse, not a transactional database, and doesn't provide the necessary ACID properties for real-time transaction processing. Cloud SQL offers ACID properties but is a regional database, making Cloud Spanner a better choice for global scale and high availability often required by banking systems. While federated queries can link Cloud SQL to BigQuery, this setup doesn't address the primary storage solution for transactional data requiring global ACID guarantees.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed