Answer-first summary for fast verification
Answer: Store transaction data in Cloud Spanner and use locking read-write transactions.
The correct answer is **B**. Storing transaction data in Cloud Spanner and using locking read-write transactions ensures ACID compliance and strong consistency, which are critical for bank account transactions. Cloud Spanner is designed for large-scale transactional workloads across multiple regions, offering the scalability and performance needed. - **Option A** is incorrect because enabling stale reads can lead to accessing outdated data, compromising consistency and ACID compliance. - **Option C** is incorrect because BigQuery does not provide the transactional support required for bank account transactions, and disabling the query cache does not ensure ACID compliance. - **Option D** is incorrect because Cloud SQL may not offer the same level of distributed transaction support and scalability as Cloud Spanner, making it less suitable for large-scale transactional workloads.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You work for a major bank with operations across North America. Your task is to set up a data storage system for managing bank account transactions that must comply with ACID principles and allow SQL data access. Which solution would best meet these requirements?
A
Store transaction data in Cloud Spanner and enable stale reads to reduce latency.
B
Store transaction data in Cloud Spanner and use locking read-write transactions.
C
Store transaction data in BigQuery and disable the query cache to ensure consistency.
D
Store transaction data in Cloud SQL and use a federated query with BigQuery for analysis.
No comments yet.