Google Professional Cloud Developer Question 156
Select 3Google Cloud PlatformYou are developing a new e-commerce application that needs to store different types of data: user profiles, order transactions, product catalog metadata, and real-time clickstream logs. You want to ensure the data is stored in a cost-efficient and performant manner. Which storage options should you choose for this application?
- A
Use Cloud SQL for storing user profiles and order transactions.
- B
Use Cloud Bigtable for storing the product catalog metadata.
- C
Use Cloud Storage for storing real-time clickstream logs.
- D
Use Firestore for storing user profiles and product catalog metadata.
- E
Use BigQuery for storing and analyzing real-time clickstream logs.
Show answer and explanation
Correct answers: A, D, E
Explanation
Each type of data in the e-commerce application has different requirements for storage in terms of structure, performance, and cost. Cloud SQL is ideal for structured, transactional data like user profiles and order transactions. Firestore is a good fit for semi-structured data such as user profiles and catalog metadata. BigQuery is designed for analytics on massive datasets like clickstream logs, enabling efficient querying and analysis. Cloud Bigtable and Cloud Storage are better suited for other specific use cases and are not optimal for the described application needs.
- A. Correct.
Cloud SQL is a good choice for structured, transactional data such as user profiles and order transactions due to its support for ACID compliance and relational data models.
- B. Incorrect.
Cloud Bigtable is optimized for low-latency, high-throughput use cases but is not ideal for storing product catalog metadata, which typically requires a structured, relational database.
- C. Incorrect.
Cloud Storage is better suited for unstructured data such as media files, rather than structured data like clickstream logs that require analysis.
- D. Correct.
Firestore is a NoSQL database that works well for hierarchical and semi-structured data, making it suitable for user profiles and product catalog metadata.
- E. Correct.
BigQuery is an excellent choice for storing and analyzing large-scale clickstream logs due to its ability to process massive datasets efficiently for analytics.