Google Professional Cloud Developer Question 196
Select 2Google Cloud PlatformYou are designing a cloud-based application to manage an e-commerce platform. The application needs to process thousands of customer orders per second, including inventory updates and payment transactions. Additionally, the business team wants to generate complex analytical reports on sales trends and customer behavior. Which combination of Google Cloud services would you recommend for handling both the transaction processing and analytical reporting requirements?
- A
Use Cloud Spanner for transaction processing and BigQuery for analytical reporting.
- B
Use Firestore for transaction processing and Bigtable for analytical reporting.
- C
Use Cloud SQL for transaction processing and BigQuery for analytical reporting.
- D
Use Bigtable for transaction processing and Dataflow for analytical reporting.
- E
Use Cloud Spanner for transaction processing and Dataproc for analytical reporting.
Show answer and explanation
Correct answers: A, C
Explanation
For applications that require both OLTP and data warehousing capabilities, the best approach is to use a combination of services specifically designed for each workload. Cloud Spanner and Cloud SQL are both highly capable for handling transactional workloads (OLTP), while BigQuery excels at handling analytical queries and reporting as a data warehouse. The correct answers identify these optimal combinations.
- A. Correct.
Cloud Spanner is a horizontally scalable, globally distributed relational database suitable for high-throughput online transaction processing (OLTP). BigQuery is an excellent choice for analytical reporting (data warehousing). This combination meets both requirements.
- B. Incorrect.
Firestore is a NoSQL document database optimized for real-time applications but is less suitable for traditional high-throughput OLTP workloads. Bigtable is a NoSQL wide-column database optimized for low-latency analytical workloads but not for complex queries or reporting.
- C. Correct.
Cloud SQL is a managed relational database suited for OLTP workloads, making it a good choice for transaction processing. BigQuery is a great option for analytical reporting, making this combination valid.
- D. Incorrect.
Bigtable is optimized for large-scale, low-latency data operations but is not suitable for OLTP workloads. Dataflow is a stream/batch data processing tool, not a database or data warehouse for analytical reporting.
- E. Incorrect.
Cloud Spanner is suitable for OLTP, but Dataproc is a managed Spark/Hadoop service for data processing and is not optimized for complex analytical reporting like BigQuery.