The answer is Firestore in Datastore mode with document keys. This is the correct choice because Firestore is a fully managed NoSQL document database that natively stores JSON documents and provides automatic sharding, meaning it scales seamlessly from 10 GB to 500 GB without requiring manual partitioning or reconfiguration. For workloads where data is frequently accessed by key but rarely updated, Firestore’s document keys enable highly efficient, strongly consistent point reads, making it ideal for this pattern. On the Google Professional Cloud Database Engineer exam, this question tests your ability to distinguish between Firestore and Bigtable: a common trap is choosing Bigtable for large-scale key-value access, but Bigtable is optimized for high-throughput, wide-column workloads with eventual consistency, not for JSON document storage with strong consistency. Remember the memory tip: “JSON keys? Firestore frees you from Bigtable’s wide-column chains.”
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 developer needs to store JSON documents that are frequently accessed by key but rarely updated. The data size is under 10 GB initially but expected to grow to 500 GB. Which database service is most suitable?
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Firestore (Datastore mode) with document keys
Firestore in Datastore mode is ideal because it provides a fully managed, scalable NoSQL document database with automatic sharding and strong consistency for key-based lookups. It handles growth from 10 GB to 500 GB seamlessly without manual partitioning, and its document keys enable efficient point reads for frequently accessed, rarely updated JSON data.
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.
✓
Firestore (Datastore mode) with document keys
Why this is correct
Firestore provides document store with automatic scaling and low-latency key lookups.
Related concept
Read the scenario before looking for a memorised answer.
✗
Cloud Bigtable with row keys as document IDs
Why it's wrong here
Bigtable is optimized for analytical workloads, not document storage with frequent key lookups.
✗
Memorystore for Redis with JSON data type
Why it's wrong here
Redis is in-memory; cost prohibitive for 500 GB and not durable guaranteed.
✗
Cloud SQL for PostgreSQL with JSONB column
Why it's wrong here
JSONB works but relational model may not scale to 500 GB with same performance as Firestore for key access.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often choose Cloud Bigtable (B) for large-scale key-value workloads, overlooking that Bigtable is designed for wide-column, high-throughput analytical access patterns, not for storing JSON documents with frequent point reads by key.
Detailed technical explanation
How to think about this question
Firestore in Datastore mode uses a distributed, auto-sharded architecture where each document key is hashed to determine its tablet location, enabling O(1) point reads regardless of dataset size. Under the hood, it leverages Google's Spanner for strong consistency and automatic replication, so even as data grows from 10 GB to 500 GB, read latency remains consistently low without manual index tuning. In a real-world scenario, this is ideal for a user profile service where each user's JSON document is accessed by a unique user ID and rarely updated, such as in a gaming leaderboard or e-commerce customer database.
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
A company's IT admin needs to give a contractor read-only access to production logs without sharing account credentials. Using role-based access control (RBAC) and temporary scoped permissions — not a permanent shared password — is the correct pattern. Questions like this test whether you can apply least-privilege access across cloud identity services.
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: Firestore (Datastore mode) with document keys — Firestore in Datastore mode is ideal because it provides a fully managed, scalable NoSQL document database with automatic sharding and strong consistency for key-based lookups. It handles growth from 10 GB to 500 GB seamlessly without manual partitioning, and its document keys enable efficient point reads for frequently accessed, rarely updated JSON data.
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.