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.
Correct Answer:
Verified
Q146: You plan to deploy Cloud SQL using
Q147: You have data pipelines running on BigQuery,
Q148: After migrating ETL jobs to run on
Q149: You are analyzing the price of a
Q150: You need to deploy additional dependencies to
Q152: You are building new real-time data warehouse
Q153: You need to choose a database to
Q154: A shipping company has live package-tracking data
Q155: You work for a financial institution that
Q156: You are designing a pipeline that publishes
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents