Topic 1 Question 165
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?
Store transaction data in Cloud Spanner. Enable stale reads to reduce latency.
Store transaction in Cloud Spanner. Use locking read-write transactions.
Store transaction data in BigQuery. Disabled the query cache to ensure consistency.
Store transaction data in Cloud SQL. Use a federated query BigQuery for analysis.
ユーザの投票
コメント(17)
- 正解だと思う選択肢: B
I'd say B 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
👍 8devaid2022/10/04 - 正解だと思う選択肢: B
The question is hinting a requirement for global consistency, i.e. being available for NA region, which does not just include US but also Mexico, Argentina etc.
Large bank = priority over consistency over read-write
👍 4jkhong2022/12/17 This is definitely a tricky question because both B and D are "appropriate" as the question suggests, of course we can make assumptions with the "large bank" sentence but there are other questions here where making assumptions is not accepted by the community so I wonder when can we make assumptions and when we can't. I think the real problem here is the ambiguous question. This is one of the few questions where the community accept that both (B and D) answers are appropriate but some comments (and I agree) argue the BEST approach is B. I really think some questions can be written in a better and non-ambiguous way, it's just about thinking a little bit more and not conforming when a poor spelling.
👍 4cajica2023/02/05
シャッフルモード