Google Professional Cloud Database Engineer Question 78
Select 2Google Cloud PlatformYour organization is designing a new application to manage customer orders and inventory. The system must handle structured data for customer records, such as names and addresses, while also managing unstructured and semi-structured data, like product reviews and metadata. The application must support high transaction consistency for customer orders while ensuring scalability for product reviews. Which database solution(s) should you recommend?
- A
Use a SQL database for customer records and orders, and a NoSQL database for product reviews.
- B
Use a single SQL database to manage both structured and unstructured data.
- C
Use a NoSQL database exclusively to manage both structured and unstructured data.
- D
Use a SQL database for structured data and a separate NoSQL database for metadata and product reviews.
Show answer and explanation
Correct answers: A, D
Explanation
The best solution is to use a combination of SQL and NoSQL databases. SQL databases are designed for structured data with strict consistency requirements, like customer records and orders, while NoSQL databases are better for unstructured or semi-structured data, such as metadata and product reviews. This hybrid approach ensures both performance and scalability for the application.
- A. Correct.
This is correct because SQL databases are well-suited for structured data like customer records and orders, while NoSQL databases excel at handling unstructured or semi-structured data, such as product reviews.
- B. Incorrect.
This is incorrect because SQL databases are not optimized for managing unstructured or semi-structured data, and using a single database for both types of data can lead to performance and scalability issues.
- C. Incorrect.
This is incorrect because NoSQL databases are not ideal for managing highly structured data with strict consistency requirements, such as customer records and orders.
- D. Correct.
This is correct because it aligns with best practices: SQL databases handle structured data with strong consistency, while NoSQL databases handle unstructured or semi-structured data, providing scalability and flexibility.