Google Professional Cloud Database Engineer Question 79
Single answerGoogle Cloud PlatformYour company needs to build an application to handle a large volume of user-generated content, such as customer reviews and ratings. The data includes unstructured text, timestamps, and numerical ratings. The application must scale seamlessly to handle traffic spikes and allow for flexible schema updates as new features are added. Which type of database would best suit this requirement?
- A
Relational SQL database such as Cloud SQL
- B
NoSQL document database such as Firestore
- C
NoSQL key-value database such as Cloud Bigtable
- D
Data warehouse solution such as BigQuery
Show answer and explanation
Correct answer: B
Explanation
NoSQL document databases like Firestore are well-suited for applications requiring schema flexibility and the ability to handle unstructured or semi-structured data, such as customer reviews and ratings. These databases are also highly scalable and can handle traffic spikes, making them the best choice for this scenario.
- A. Incorrect.
Relational SQL databases are best suited for highly structured data with fixed schemas and strong consistency requirements. They are less ideal for handling unstructured text and schema flexibility.
- B. Correct.
NoSQL document databases like Firestore are designed to handle unstructured or semi-structured data, provide schema flexibility, and scale seamlessly, making them ideal for applications like user-generated content.
- C. Incorrect.
NoSQL key-value databases like Cloud Bigtable are optimized for large-scale analytical workloads and time-series data, but they are less suited for handling unstructured text or schema evolution.
- D. Incorrect.
Data warehouse solutions like BigQuery are designed for analytical queries on structured or semi-structured data at scale, but they are not typically used for operational workloads or unstructured text.