GCP Associate Cloud Engineer Practice Question 75: Firestore Mobile Offline Sync
Google Cloud Associate Cloud Engineer · Test 8 · question 5 of 10
A mobile app team is building a note taking app. Notes must sync in real time across a user's devices, remain usable and editable while a device is offline, and automatically sync once connectivity returns. Which GCP database should they use for storing the notes?
Show answer and explanation
Answer:
Firestore is a document database purpose built for mobile and web apps: its client SDKs cache data locally, let the app read and write while offline, and automatically sync and resolve state once the device reconnects, and its real time listeners push changes to other devices immediately.
Option B, Cloud SQL, is a managed relational database meant to be reached from backend infrastructure; it has no offline cache and mobile devices connecting to it directly through a proxy is not a supported or practical pattern. Option C, BigQuery, is an analytical data warehouse optimized for large scale querying, not for low latency single record reads and writes from a mobile app. Option D, Bigtable, is a wide column store for high throughput analytical or time series workloads and has no offline client support or document level real time sync.
Reference: Firestore for mobile apps