nerdexam
Google

PROFESSIONAL-CLOUD-DEVELOPER · Question #81

Your existing application keeps user state information in a single MySQL database. This state information is very user-specific and depends heavily on how long a user has been using an application. Th

The correct answer is D. Cloud Datastore/Firestore. Cloud Datastore/Firestore is a NoSQL document database that stores data as schemaless documents, making it ideal when each user has a unique, evolving set of fields. Unlike relational databases, there is no fixed schema to maintain or migrate - each document can have different at

Designing and implementing application data storage

Question

Your existing application keeps user state information in a single MySQL database. This state information is very user-specific and depends heavily on how long a user has been using an application. The MySQL database is causing challenges to maintain and enhance the schema for various users. Which storage option should you choose?

Options

  • ACloud SQL
  • BCloud Storage
  • CCloud Spanner
  • DCloud Datastore/Firestore

How the community answered

(57 responses)
  • A
    9% (5)
  • B
    2% (1)
  • C
    5% (3)
  • D
    84% (48)

Explanation

Cloud Datastore/Firestore is a NoSQL document database that stores data as schemaless documents, making it ideal when each user has a unique, evolving set of fields. Unlike relational databases, there is no fixed schema to maintain or migrate - each document can have different attributes. This eliminates the schema management pain described in the question. Cloud SQL (A) is managed MySQL/PostgreSQL and has the same schema rigidity problem. Cloud Spanner (C) is a globally distributed relational database - also schema-bound. Cloud Storage (B) is an object store, not a queryable database.

Topics

#NoSQL Databases#Schema Flexibility#Database Selection#Application Data

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DEVELOPER Practice