Google Professional Cloud Database Engineer Question 76
Single answerGoogle Cloud PlatformYour team is building a new application to manage customer feedback for an e-commerce platform. The feedback data includes a mix of structured fields (e.g., customer ID, product ID, rating) and unstructured information (e.g., free-text comments). The feedback system needs to scale dynamically, handle frequent updates, and support advanced querying for analytics (e.g., finding patterns in customer sentiment or filtering feedback by product categories). Which database type would best suit this use case?
- A
Relational SQL database, such as Cloud SQL
- B
Document-based NoSQL database, such as Firestore or MongoDB
- C
Key-value NoSQL database, such as Cloud Bigtable
- D
Graph database, such as Neo4j or Amazon Neptune
Show answer and explanation
Correct answer: B
Explanation
A document-based NoSQL database is the best choice for this use case because it can handle both structured and unstructured data, scale dynamically as the application grows, and support advanced querying for analytics. SQL databases would be limited by their rigid schema, while key-value and graph databases would not meet the requirements for managing free-text comments and complex queries effectively.
- A. Incorrect.
Relational SQL databases are great for structured data and complex transactional operations, but they are not ideal for unstructured data like free-text comments or situations requiring dynamic scaling and schema flexibility.
- B. Correct.
Document-based NoSQL databases are well-suited for handling both structured and unstructured data. They offer schema flexibility, dynamic scalability, and advanced query capabilities, making them the best fit for this use case.
- C. Incorrect.
Key-value NoSQL databases are optimized for high-performance, simple lookup operations and are not designed for handling structured and unstructured data together or supporting advanced querying.
- D. Incorrect.
Graph databases are specialized for managing and querying relationships and connections between entities, but they are not a good fit for this feedback system, which focuses on structured and unstructured data with analytical queries.