Answer-first summary for fast verification
Answer: Use Cloud Spanner to store transaction data and utilize locking read-write transactions
The correct choice is to use Cloud Spanner with locking read-write transactions. Cloud Spanner combines the scalability of NoSQL databases with the benefits of relational databases, including ACID compliance and SQL access. Locking read-write transactions are crucial for maintaining data integrity during writes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a data engineer for a large bank operating across North America, you're responsible for storing and managing transaction data. The solution must ensure ACID compliance and allow SQL access. Which option meets these requirements?
A
Store transaction data in BigQuery and disable the query cache to ensure consistency
B
Use Cloud SQL to store transaction data and use federated queries in BigQuery for analysis
C
Use Cloud Spanner to store transaction data and enable stale reads to reduce latency
D
Use Cloud Spanner to store transaction data and utilize locking read-write transactions
No comments yet.