Google Professional Cloud Developer Question 170
Single answerGoogle Cloud PlatformYou are developing an e-commerce application on Google Cloud and need to choose a database for storing product catalog data. The product catalog includes structured data such as product names, prices, and inventory counts, but also includes unstructured data such as detailed product descriptions and user-uploaded images. Which database solution best supports this use case?
- A
Cloud SQL for storing structured data and Cloud Storage for unstructured data
- B
Firestore for both structured and unstructured data
- C
Bigtable for storing all data types in a single NoSQL solution
- D
Cloud Spanner for managing both structured and unstructured data
Show answer and explanation
Correct answer: A
Explanation
The correct solution involves using the right tools for the job. In this case, Cloud SQL is ideal for structured, relational data such as product names and prices, while Cloud Storage is highly optimized for handling unstructured data such as images and large text blobs. Combining these services provides a scalable and efficient architecture for this e-commerce application.
- A. Correct.
Correct. Cloud SQL is a managed relational database that works well for structured data like product names and prices, while Cloud Storage is ideal for storing unstructured data such as images and descriptions.
- B. Incorrect.
Incorrect. Firestore is a NoSQL database optimized for hierarchical, document-based structured data, but it is not suitable for heavy unstructured data storage like images.
- C. Incorrect.
Incorrect. Bigtable is a NoSQL database designed for analytical workloads and time-series data, but it is not ideal for handling diverse structured and unstructured data in this use case.
- D. Incorrect.
Incorrect. Cloud Spanner is a globally distributed relational database suitable for structured data but is not optimized for storing unstructured data like images.