You are developing a mobile application that allows users to create and manage to-do lists. Your application has the following requirements: - Store and synchronize data between different mobile devic

Question

Options

• ACreate a Cloud SQL for MySQL instance. Implement a data model to store to-do list information.
• BCreate a Bigtable instance. Design a database schema to avoid hotspots when writing data. Use
• CUse Firestore as the database. Configure Firestore offline persistence to cache a copy of the
• DImplement a SQLite database on each user's device. Use a scheduled job to synchronize each

• A
  8% (2)
• B
  12% (3)
• C
  76% (19)
• D
  4% (1)

Explanation

Firestore is purpose-built for mobile and web applications and natively satisfies all three requirements out of the box: (1) real-time listeners push updates to all connected devices instantly, (2) the Firestore SDK has built-in offline persistence that caches data locally and syncs when connectivity is restored, and (3) it is a fully managed serverless database requiring minimal operational effort. Cloud SQL (A) is a relational VM-based database with no offline sync capability. Bigtable (B) is a high-throughput analytics database, not designed for mobile clients or offline-first patterns. SQLite with a scheduled sync job (D) does not provide real-time updates and requires significant custom engineering for conflict resolution and sync logic.

No community discussion yet for this question.