ExpertMedium1 markMultiple Choice
GCP ACE · Question 15 · Domain 2.3: Planning and configuring data storage options
Your company is building a global inventory management system. The database must be fully relational (SQL), support strong consistency, and scale horizontally to handle thousands of transactions per second across multiple continents.
Which GCP database service should you choose?
Your company is building a global inventory management system. The database must be fully relational (SQL), support strong consistency, and scale horizontally to handle thousands of transactions per second 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
Match the requirements: 'relational (SQL)', 'global', 'horizontal scaling', 'strong consistency'.
Full Answer
B.Cloud Spanner✓ Correct
Cloud Spanner
Cloud Spanner is specifically designed for this use case. It combines the benefits of relational database structure (SQL, ACID transactions, strong consistency) with non-relational horizontal scale and global distribution.
Common mistakes
Choosing Cloud SQL, which is limited to vertical scaling for writes and is constrained to a single region.
Practice the full GCP Associate Cloud Engineer Practice Exam 2
50 questions · hints · full answers · grading
More questions from this exam
Q01Your company is migrating to Google Cloud and needs to establish a resource hierarchy. You have t...EasyQ02You are managing access to a GCP project. You need to grant 15 developers the ability to view Com...MediumQ03You have created a new GCP project using the Cloud Console. You want to deploy a Cloud Function u...EasyQ04Your startup has a strict monthly cloud budget of $500. You want to be notified immediately if yo...EasyQ05Your finance team wants to perform complex SQL analysis on your GCP billing data to understand co...Medium