Google Professional Data Engineer
Get started today
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?
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?
Explanation:
The correct answer is B. Cloud Spanner is designed for global scalability and strong consistency, making it ideal for a large bank's transaction system that requires ACID compliance and SQL access. Locking read-write transactions ensure data integrity and prevent conflicts. While Cloud SQL also provides ACID compliance, it does not scale horizontally as efficiently as Cloud Spanner for large volumes. BigQuery is not a suitable option because it does not natively support ACID transactions or SQL writes, which are necessary for banking transactions.