easyMultiple Choice
PDE Practice Question: Process real-time clickstream data and store it…
A company needs to process real-time clickstream data and store it in a data warehouse for SQL-based analytics. The data volume is moderate. Which combination of Google Cloud services is most cost-effective?
⚠ Common exam trap
Google Cloud often tests the misconception that Cloud Storage is a suitable destination for analytics-ready data, but it lacks native SQL querying, forcing candidates to overlook BigQuery's direct integration with Dataflow for real-time analytics.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Cloud Pub/Sub, Cloud Dataflow, BigQuery
Cloud Pub/Sub ingests real-time clickstream data, Cloud Dataflow processes it with low latency, and BigQuery provides a serverless, SQL-based data warehouse that is cost-effective for moderate data volumes due to its pay-per-query pricing and automatic scaling. This combination avoids the overhead of managing clusters (Dataproc) or expensive storage (Cloud Spanner) while directly supporting SQL analytics.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Cloud Pub/Sub, Cloud Dataproc, Cloud Storage
Why it's wrong here
Cloud Dataproc runs batch Hadoop and Spark clusters, not the managed streaming pipeline needed for real-time clickstream processing, and Cloud Storage cannot serve SQL analytics. It is tempting because Dataproc handles large-scale data processing, and would be correct for periodic batch jobs rather than continuous streaming.
- ✗
Cloud Pub/Sub, Cloud Dataflow, Cloud Spanner
Why it's wrong here
Cloud Spanner is a globally distributed OLTP database, not a data warehouse, so it cannot deliver the required SQL analytical workload cost-effectively. It is tempting because Spanner offers strong consistency and SQL, and would be correct for horizontally scalable transactional applications rather than analytics.
- ✓
Cloud Pub/Sub, Cloud Dataflow, BigQuery
Why this is correct
Pub/Sub ingests the clickstream, Dataflow performs streaming transformation, and BigQuery stores the results for SQL analytics. This serverless trio scales automatically and bills per use, suiting moderate volume without provisioning idle capacity, unlike Dataproc or Bigtable alternatives.
- ✗
Cloud Pub/Sub, Cloud Dataflow, Cloud Storage
Why it's wrong here
Cloud Storage is object storage, not a data warehouse, so it cannot serve the required SQL-based analytics directly; Dataflow is also unnecessary for moderate volume. It is tempting because this pipeline is the canonical streaming pattern, and would be correct when the destination is a data lake rather than a warehouse.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
About these practice questions
One of 747 original PDE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PDE exam.