Google Professional Cloud Database Engineer Question 77
Single answerGoogle Cloud PlatformYou are designing a database for a retail company that stores large amounts of product catalog data. The data includes hierarchical structures such as product categories and subcategories, and the catalog structure is expected to change frequently. Additionally, the company requires the ability to search and retrieve data quickly based on various attributes such as name, price, and availability. Which type of database would you recommend for this use case?
- A
Relational Database (SQL)
- B
Document Database (NoSQL)
- C
Key-Value Store (NoSQL)
- D
Time Series Database (NoSQL)
Show answer and explanation
Correct answer: B
Explanation
The correct answer is 'Document Database (NoSQL)' because it provides the flexibility needed for hierarchical and semi-structured data. It allows easy adaptation to changes in the catalog structure and supports efficient querying across various attributes, which aligns well with the business requirements of the retail company.
- A. Incorrect.
Relational databases (SQL) are better suited for structured data with fixed schemas. Since the product catalog structure changes frequently and includes hierarchical data, a relational database may not handle these requirements efficiently.
- B. Correct.
Document databases (NoSQL) are well-suited for hierarchical and semi-structured data. They support flexible schemas and allow quick retrieval of data based on attributes, making them an ideal choice for this use case.
- C. Incorrect.
Key-value stores (NoSQL) are optimized for simple key-value lookups and are not ideal for complex queries or hierarchical data like the product catalog in this scenario.
- D. Incorrect.
Time series databases (NoSQL) are designed for storing and analyzing time-stamped data, such as monitoring metrics or IoT data, and are not suitable for hierarchical or product catalog data.