Your organization is developing an application that will manage payments and online bank accounts located around the world. The most critical requirement for your database is that each transaction is handled consistently. Your organization anticipates almost unlimited growth in the amount of data stored.
Which Google Cloud product should your organization choose?
C
Features of Cloud Spanner -
Reference:
https://k21academy.com/google-cloud/cloud-sql-vs-cloud-spanner/
CloudSpanner is the correct answer. Firestore is for mobile applications developed from Firebase, GCS is not a Database and Cloud SQL is to simple for this amout of data.
Good answer but Firestore is not only or mobile apps. The reason it is not the correct answer is the limitations analyzed here. Essentially it does not cover the unlimited growth. https://firebase.google.com/docs/firestore/quotas#collections_documents_and_fields
Cloud Spanner is a fully managed, globally distributed relational database service provided by Google Cloud. It combines the benefits of traditional relational databases, such as ACID transactions and SQL queries, with the scalability and high availability of a distributed system. It is specifically designed to meet the requirements of handling globally consistent transactions and scaling to handle large amounts of data. With its strong consistency guarantees, scalability, and global distribution capabilities, Cloud Spanner is well-suited for applications that require consistent transaction handling and anticipate significant data growth. It provides a robust and reliable database solution for managing payments and online bank accounts located worldwide.
The other options are not as suitable for this purpose. Cloud SQL: Cloud SQL is a managed database service that offers a variety of relational database engines, including MySQL, PostgreSQL, and SQL Server. However, Cloud SQL does not offer transactional consistency at global scale. Cloud Storage: Cloud Storage is a object storage service that is designed for storing large amounts of unstructured data. It is not a relational database and does not offer transactional consistency. Firestore: Firestore is a NoSQL document database that is designed for mobile and web applications. It is not a relational database and does not offer transactional consistency.
Cloud Spanner is a globally distributed, horizontally scalable, and strongly consistent relational database service offered by Google Cloud. It provides the ability to scale both storage and compute resources as needed, ensuring consistent transaction handling across multiple regions. This makes it an ideal choice for applications that require strong consistency and high scalability. While options A (Cloud SQL), B (Cloud Storage), and C (Firestore) are also valuable Google Cloud products, they may not meet the specific requirements mentioned in the context as effectively as Cloud Spanner. Cloud SQL is a managed relational database service, but it may not provide the same level of scalability and global consistency as Cloud Spanner. Cloud Storage is a scalable object storage solution, and Firestore is a NoSQL document database, but they may not offer the same level of transaction consistency required for managing payments and online bank accounts.
Cloud Spanner as it is database recommended for any banking or gaming related industry where the volumes of data is high
CloudSpanner is the correct answer. Cloud Spanner is well-suited for transactional workloads with strong consistency requirements across multiple regions. If your focus is more on performing transactional SQL queries against historical data, ensuring strong consistency, and managing relational database workloads, Cloud Spanner would be a suitable choice.
D. Cloud Spanner is the correct answer. 1. Globally distributed, 2. horizontally scalable, 3. strongly consistent relational database service, 4. ensuring consistent transaction handling across multiple regions, 5. Transactional, mission-critical, and unlimited growth.
Firestore is a noSQL database, not a good choice when transactional consistency is a requirement
Thought the correct answer is Cloud spanner. But when clicked on reveal solution it says Answer is C which is Firestore ... And again the in the explanation boxed opened , Correct Answer is mentioned as C , but explains cloud spanner.
Cloud Spanner
C is correct
Cloud Spanner is a fully managed, mission-critical, relational database service that offers transactional consistency at global scale, schemas, SQL (ANSI 2011 with extensions), and automatic, synchronous replication for high availability.
cloud spanner is accurate
D is correct
Cloud Spanner
"...an application that will manage payments and online bank accounts located around the world." This gives us several hints: it's a transactional workload, because it's for bank and managing payments, and it's almost certainly a SQL database we are talking about. Finally it needs to scale horizontally, because it says "around the world", global expansion. Only Spanner satisfies all conditions. D is Correct. (Also Firestore is dor noSQL document databases, mainly for web apps, not a good solution at all)
CLOUD SPANNER