ExpertMedium1 markMultiple Choice
GCP ACE · Question 16 · Domain 2.3: Planning and configuring data storage options
You are designing the database backend for a new global e-commerce platform. The database must support strong relational consistency (ACID transactions), handle massive horizontal scaling to support millions of users globally, and provide high availability across multiple regions.
Which Google Cloud database service is the BEST fit for these requirements?
You are designing the database backend for a new global e-commerce platform. The database must support strong relational consistency (ACID transactions), handle massive horizontal scaling to support millions of users globally, and provide high availability across multiple regions.
Which Google Cloud database service is the BEST fit for these requirements?
Answer options:
A.
Cloud SQL
B.
Cloud Bigtable
C.
Cloud Spanner
D.
Firestore
How to approach this question
Look for the combination of 'relational/ACID' AND 'global horizontal scaling'. This unique combination points exclusively to Cloud Spanner.
Full Answer
C.Cloud Spanner✓ Correct
Cloud Spanner
Cloud Spanner is the only Google Cloud database service that combines the benefits of relational database structure (schemas, SQL queries, strong ACID consistency) with non-relational horizontal scale (scaling across multiple regions globally). Cloud SQL is relational but scales vertically and is regional. Bigtable and Firestore scale globally but are NoSQL databases.
Common mistakes
Choosing Cloud SQL because it's relational, ignoring the 'massive horizontal scaling globally' requirement.
Practice the full GCP Associate Cloud Engineer Practice Exam 6
50 questions · hints · full answers · grading
More questions from this exam
Q01What is the primary purpose of a Google Cloud project?EasyQ02Your development team needs to manage Compute Engine instances in a specific project. They need t...MediumQ03You are automating the setup of a new Google Cloud project using a bash script. You need to enabl...EasyQ04Your startup has a strict monthly cloud budget of $500. You want to be notified immediately if yo...MediumQ05Your finance team wants to perform granular analysis of your Google Cloud spending using SQL. The...Hard