Answer-first summary for fast verification
Answer: Cloud Datastore/Firestore
The existing application faces challenges with maintaining a rigid schema in MySQL, especially since the user state data is highly user-specific and varies over time. Cloud Datastore/Firestore (option D) is a NoSQL document database that offers a flexible schema design, allowing each user's data to be stored without predefined schemas. This eliminates schema migration issues and supports varying data structures as users' needs evolve. Cloud SQL (A) retains the same schema constraints as MySQL. Cloud Storage (B) is for unstructured object storage. Cloud Spanner (C) is a relational database with schema requirements, making it unsuitable for the stated flexibility needs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Your application currently stores user state information in a single MySQL database, with data being highly user-specific and dependent on individual usage duration. Maintaining and enhancing the schema for diverse users has become challenging.
Which storage solution would best address this issue?
A
Cloud SQL
B
Cloud Storage
C
Cloud Spanner
D
Cloud Datastore/Firestore