Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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
