CLOUD-DIGITAL-LEADER practice question 25 of 35
A multinational retail company has approached you to help design its systems. They have millions of transactions at their point of sale systems across the world that need to be captured, stored, and analyzed. They are seeing more growth and expect to expand into even more geographies. Which database would be appropriate for them?
Full set: 411 questionsCloud Spanner is Google Cloud’s fully-managed, relational database that delivers horizontal scaling, strong ACID transactions, and synchronous replication across regions. It is explicitly designed for high-volume, globally-distributed OLTP workloads such as retail point-of-sale systems that generate millions of transactions per day and must continue to grow into new geographies while maintaining consistency and availability. Datastore and Cloud Storage are non-relational/object stores, and Cloud SQL is limited to single-region instances and vertical scaling, making them unsuitable for the stated scale and global consistency needs.
A. Cloud Datastore – Document NoSQL store; lacks relational schema and global, strongly consistent transactions needed for POS financial data.
B. Cloud Storage – Object storage; not a database, no transactional semantics or query capabilities.
D. Cloud SQL – Single-region, vertically scaled MySQL/PostgreSQL/SQL Server; cannot provide global horizontal scalability or multi-region consistency.
1. Google Cloud documentation, “Cloud Spanner: Horizontally scalable, strongly consistent, relational database service,” Product overview, para. 1-3 (https://cloud.google.com/spanner/docs).
2. Google Cloud, “Choose Your Google Cloud Database,” Table 1: Workload vs. product fit, last updated 2023-10-12.
3. J. C. Corbett et al., “Spanner: Google’s globally-distributed database,” ACM Trans. Comput. Syst., 31(3), 2013, pp. 1-22, DOI:10.1145/2491245 – Sec. 1 (global scalability) & Sec. 7 (performance).
4. Stanford CS345A Course Notes, “Cloud Data Management Systems,” Lecture 5, slide 21: Cloud Spanner characteristics (global transactions, horizontal scale).
Keep practicing
Take the free CLOUD-DIGITAL-LEADER practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CLOUD-DIGITAL-LEADER practice questions
- Question 1Your organization needs to ensure that the Google Cloud resources of each of your departm…
- Question 2A vacation home rental organization wants to predict the popularity of properties in thei…
- Question 3You are consulting for a client who is migrating to Google Cloud. They presently have a m…
- Question 4Which of the following is/are true about Anthos?
- Question 5What are the network requirements for Private Google Access?
- Question 6Your company security team manages access control to production systems using an LDAP dir…
