Exam Professional Cloud Developer topic 1 question 37 discussion

Question sais that there are challenges to maintain and enhance schema, so schemaless DB is more preferable, moreover google mention that Datastore/Firestore is good for users profiles (https://cloud.google.com/datastore/docs/concepts/overview#what_its_good_for) Answer: D)

Resposta D

D. Cloud Datastore/Firestore For user-specific state information that varies significantly and requires a schema that can evolve over time, a NoSQL database like Cloud Datastore or Firestore is typically more appropriate. These databases provide a flexible schema, which allows you to easily make changes as the application evolves and user requirements become more complex.

The last sentence subtly implies a schema-enforced database is not the right solution for this use case.

Since we need a flexible schema we can use Datastore/Firestore

The question is a bit misleading. If its asking to keep a MySQL storage option then Cloud SQL or Spanner are the only options. However, assuming that they want to move away from schema and also the need for stateful DB I would go for Datastore/Firestore.

Out of the options provided, Cloud Datastore or Cloud Firestore would be the best choice for storing user state information that is very user-specific and depends heavily on how long a user has been using an application. This is because both Cloud Datastore and Cloud Firestore are NoSQL document databases designed for storing, retrieving, and managing semi-structured data at scale. They are well-suited for storing complex, hierarchical data structures and can handle a high volume of read and write operations. Additionally, Cloud Datastore and Cloud Firestore offer strong consistency and automatic scaling, which can help your application handle a high volume of users without requiring significant manual effort to maintain and enhance the schema.

Option D

https://cloud.google.com/datastore/docs/concepts/overview#what_its_good_for -> "User profiles that deliver a customized experience based on the user’s past activities and preferences". Answer id D.

D is correct

D for sure

D is right one.

D is the answer

D is correct answer