ExpertHard1 markMultiple Choice
Domain 2.3: Planning and configuring data storage optionsCloud SpannerDatabase SelectionRelational Database
GCP ACE · Question 16 · Domain 2.3: Planning and configuring data storage options
You are designing the database backend for a new global multiplayer game. The database must support strong relational consistency (ACID transactions), handle millions of reads and writes per second, and scale horizontally across multiple regions worldwide without sharding the database manually.
Which Google Cloud database service should you choose?
You are designing the database backend for a new global multiplayer game. The database must support strong relational consistency (ACID transactions), handle millions of reads and writes per second, and scale horizontally across multiple regions worldwide without sharding the database manually.
Which Google Cloud database service should you choose?
Answer options:
A.
Cloud SQL
B.
Cloud Bigtable
C.
Cloud Spanner
D.
Firestore
How to approach this question
Identify the keywords: 'relational consistency (ACID)', 'scale horizontally', and 'multiple regions worldwide'.
Full Answer
C.Cloud Spanner✓ Correct
Cloud Spanner
Cloud Spanner is the only Google Cloud database that offers the combination of relational database structure (SQL, ACID transactions) and non-relational horizontal scalability across regions. It is designed specifically for global, high-throughput transactional workloads.
Common mistakes
Choosing Cloud SQL because it's relational, forgetting that it cannot scale writes horizontally across regions. Or choosing Bigtable for scale, forgetting it lacks relational ACID transactions.
Practice the full GCP Associate Cloud Engineer Practice Exam 7
50 questions · hints · full answers · grading
More questions from this exam
Q01You are starting a new initiative and need to create a new Google Cloud project using the Cloud S...EasyQ02Your company is migrating to Google Cloud and wants to manage user identities centrally. They cur...MediumQ03You have just created a new Google Cloud project and want to deploy a containerized application u...MediumQ04Your finance team wants to perform complex SQL queries on your Google Cloud billing data to analy...MediumQ05You are managing a development project in Google Cloud. You want to ensure that you are notified ...Easy