Google Professional Cloud Database Engineer Question 84
Single answerGoogle Cloud PlatformYour company is building a new customer feedback application. The application will collect reviews, ratings, and multimedia files such as images and videos. Additionally, users can provide additional details in JSON objects with varying schemas. Which Google Cloud database service would be the most suitable to store and query this data efficiently?
- A
Cloud Spanner
- B
Cloud SQL
- C
Firestore
- D
Cloud Storage
Show answer and explanation
Correct answer: C
Explanation
Firestore is the most suitable choice because it is a NoSQL database optimized for semi-structured data like JSON objects with varying schemas. It also supports real-time synchronization and scalability, which are beneficial for the customer feedback application. While Cloud Storage is excellent for storing unstructured data like multimedia files, it does not support querying JSON data. Combining Firestore with Cloud Storage could be a viable architecture for this application.
- A. Incorrect.
Cloud Spanner is a relational database designed for structured data and transactional consistency. It is not optimized for handling semi-structured or unstructured data such as multimedia files or flexible JSON schemas.
- B. Incorrect.
Cloud SQL is a relational database service that is primarily suited for structured data. While it can store some JSON data, it is not ideal for highly flexible schemas or unstructured multimedia files.
- C. Correct.
Firestore is a NoSQL database designed to handle semi-structured data like JSON objects with flexible schemas. It is also a good choice for applications requiring scalability and real-time updates, making it suitable for this use case.
- D. Incorrect.
Cloud Storage is designed for storing large amounts of unstructured data, such as multimedia files. However, it does not support querying semi-structured data like JSON objects, making it unsuitable for this use case alone.