
Ultimate access to all questions.
As a data engineer for a large bank operating across North America, you are tasked with establishing a data storage system specifically designed to handle critical bank account transactions. Given the nature of these transactions, it is imperative that the storage solution adheres to ACID (Atomicity, Consistency, Isolation, Durability) principles to ensure data reliability and consistency. Additionally, the solution must support SQL for data querying and management. Which data storage solution would be most suitable for this requirement?
A
Store transaction data in Cloud Spanner. Enable stale reads to reduce latency.
B
Store transaction in Cloud Spanner. Use locking read-write transactions.
C
Store transaction data in BigQuery. Disable the query cache to ensure consistency.
D
Store transaction data in Cloud SQL. Use a federated query BigQuery for analysis.