ExpertMedium1 markMultiple Choice
GCP ACE · Question 16 · Domain 2.3: Planning and configuring data storage options
You are designing the database backend for a global inventory management system. The system requires relational database semantics (ACID transactions, SQL queries) but must scale horizontally to handle tens of thousands of reads and writes per second globally, with strong consistency across multiple continents.
Which GCP database service should you choose?
You are designing the database backend for a global inventory management system. The system requires relational database semantics (ACID transactions, SQL queries) but must scale horizontally to handle tens of thousands of reads and writes per second globally, with strong consistency across multiple continents.
Which GCP database service should you choose?
Answer options:
A.
Cloud SQL
B.
Cloud Spanner
C.
Cloud Bigtable
D.
Firestore
How to approach this question
Identify the service that combines relational features (SQL, ACID) with global horizontal scalability.
Full Answer
B.Cloud Spanner✓ Correct
Cloud Spanner
Cloud Spanner is the only enterprise-grade, globally-distributed, and strongly consistent relational database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.
Common mistakes
Choosing Cloud SQL for global write scalability, or Bigtable when SQL/ACID is required.
Practice the full GCP Associate Cloud Engineer Practice Exam 4
50 questions · hints · full answers · grading
More questions from this exam
Q01You have recently joined a new team and need to set up a new Google Cloud project for a developme...EasyQ02Your company uses Google Workspace. You need to grant a new developer, Alice, the ability to view...MediumQ03You have created a new GCP project and want to deploy a Compute Engine instance. However, when yo...MediumQ04Your startup has a strict monthly cloud budget of $500. You want to be notified via email when yo...EasyQ05Your finance team wants to analyze Google Cloud costs using standard SQL and build custom dashboa...Medium