The answer is Cloud Firestore, as it is the only Google Cloud NoSQL database purpose-built for globally distributed mobile apps requiring high availability and low-latency key-value access with occasional secondary field queries. Firestore achieves this through automatic multi-region replication and strong consistency, while its support for composite indexes allows efficient querying on secondary fields without sacrificing performance—a critical distinction from Cloud Bigtable, which lacks native secondary indexing. On the Google Professional Cloud Database Engineer exam, this scenario tests your ability to differentiate between Firestore, Firestore in Datastore mode, and Bigtable; a common trap is choosing Bigtable for its throughput, but remember that Bigtable is optimized for analytical workloads, not mobile app real-time synchronization. The exam often frames this as a startup’s mobile app requirement, so focus on the keywords “globally distributed,” “low-latency,” and “secondary queries” to immediately flag Firestore. Memory tip: think “Firestore for mobile store”—it’s built for apps, not analytics.
PCDE Plan and manage database infrastructure Practice Question
This PCDE practice question tests your understanding of plan and manage database infrastructure. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A startup is building a mobile app that requires a highly available, globally distributed, low-latency NoSQL database. The data model is key-value with occasional queries on a secondary field. Which database service should they choose?
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Cloud Firestore
Cloud Firestore is a fully managed, globally distributed NoSQL document database that provides strong consistency, automatic multi-region replication, and low-latency queries on key-value pairs as well as secondary fields (via composite indexes). It is ideal for mobile apps requiring high availability and real-time data synchronization across the globe, directly matching the requirements of a key-value model with occasional secondary queries.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✗
Cloud SQL (PostgreSQL)
Why it's wrong here
Cloud SQL is relational and single-region; it does not offer global distribution out of the box.
✓
Cloud Firestore
Why this is correct
Firestore is a flexible NoSQL database with automatic multi-region replication, real-time updates, and strong consistency.
Related concept
Read the scenario before looking for a memorised answer.
✗
Cloud Spanner
Why it's wrong here
Spanner provides global distribution and strong consistency but is relational and more complex than needed for a simple key-value store.
✗
Cloud Bigtable
Why it's wrong here
Bigtable is a wide-column NoSQL database designed for high-throughput analytical workloads, not low-latency mobile backends.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often confuse Cloud Spanner's global distribution and strong consistency with being the best fit for NoSQL key-value workloads, overlooking that Spanner is a relational database with SQL semantics and higher operational overhead, while Firestore is purpose-built for mobile app key-value and document storage with automatic secondary indexing.
Detailed technical explanation
How to think about this question
Cloud Firestore uses a document-oriented data model where each document is a set of key-value pairs, and it automatically creates indexes for all fields to support efficient queries on any field, including secondary fields. Under the hood, Firestore leverages Google's global infrastructure with automatic multi-region replication and strong consistency via Paxos-based consensus, ensuring reads are always up-to-date. In a real-world mobile app scenario, Firestore's real-time listeners and offline persistence enable seamless user experiences even with intermittent connectivity, which is critical for globally distributed users.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
An e-commerce site experiences heavy traffic on Black Friday and near-zero traffic during off-peak weeks. Rather than provisioning permanent large VMs, the team uses auto-scaling groups that add capacity automatically under load and reduce it overnight. Questions like this test whether you understand elasticity, availability zones, and cloud compute scaling patterns.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Plan and manage database infrastructure — This question tests Plan and manage database infrastructure — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Cloud Firestore — Cloud Firestore is a fully managed, globally distributed NoSQL document database that provides strong consistency, automatic multi-region replication, and low-latency queries on key-value pairs as well as secondary fields (via composite indexes). It is ideal for mobile apps requiring high availability and real-time data synchronization across the globe, directly matching the requirements of a key-value model with occasional secondary queries.
What should I do if I get this PCDE question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
This PCDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PCDE exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.