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?

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. Disabled the query cache to ensure consistency. D. Store transaction data in Cloud SQL. Use a federated query BigQuery for analysis.