You work for a major bank with operations across North America. Your task is to set up a data storage system for managing bank account transactions that must comply with ACID principles and allow SQL data access. Which solution would best meet these requirements?

Real Exam

Store transaction data in Cloud Spanner and enable stale reads to reduce latency.

11.1%

Store transaction data in Cloud Spanner and use locking read-write transactions.

77.8%

Store transaction data in BigQuery and disable the query cache to ensure consistency.

0.0%

Store transaction data in Cloud SQL and use a federated query with BigQuery for analysis.

11.1%

Google Professional Data Engineer