PDE Storing the Data Practice Question
You need to store and query a large dataset of customer profiles. The data is semi-structured and frequently updated. The application requires offline support for mobile users. Which database is MOST appropriate?
⚠ Common exam trap
Google Cloud often tests the distinction between databases designed for transactional/operational workloads (like Firestore) versus analytical/warehouse databases (like BigQuery), and the trap here is assuming that any NoSQL database (like Bigtable) supports offline mobile sync, when in fact only Firestore provides native offline persistence and real-time synchronization for mobile clients.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Firestore
Firestore is the most appropriate choice because it is a NoSQL document database designed for semi-structured data, real-time synchronization, and offline support. It provides built-in offline persistence for mobile clients, allowing users to read and write data even without network connectivity, and automatically syncs changes when the connection is restored. This directly meets the requirements of semi-structured data, frequent updates, and offline mobile support.
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
Why this is correct
Firestore stores semi-structured documents with flexible schemas and offers real-time synchronisation plus offline persistence on mobile clients, so users can query and update profiles without connectivity. This directly satisfies the stem's offline support requirement, unlike relational databases that demand fixed schemas and constant connectivity.
- ✗
BigQuery
Why it's wrong here
BigQuery is a serverless analytical warehouse optimised for large-scale SQL scans and aggregations, not frequent per-record updates, and it has no offline mobile capability. It would be the right choice for batch analytics and reporting over petabyte-scale datasets.
- ✗
Cloud Bigtable
Why it's wrong here
Cloud Bigtable is a wide-column NoSQL store for high-throughput analytical and time-series workloads, not semi-structured profile documents, and it provides no mobile offline synchronisation. It would be correct for massive-scale, low-latency key or range scans over sparse data.
- ✗
Cloud SQL
Why it's wrong here
Cloud SQL is a relational engine, so it cannot natively model the semi-structured, schema-flexible profiles the stem describes, and it offers no offline sync mechanism for mobile clients. It is tempting because Cloud SQL suits structured transactional workloads needing SQL joins and strong consistency.
Go deeper
Related to this question
About these practice questions
This PDE question is part of Courseiva's 747-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PDE 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 PDE exam.