A 3-minute live TV voting spike must handle high write load, show partial results while open, and produce an exact once final count while minimizing cost. Which architecture meets these requirements?
Choose an answer
Tap an option to check your answer.
Correct answer: Write votes to a Pub/Sub topic and load into both Bigtable and BigQuery via a Dataflow pipeline. Query Bigtable for real-time results and BigQuery for later analysis. Shut down the Bigtable instance when voting concludes..
Why this is the answer
This architecture is optimal because Pub/Sub handles the high ingress write load, decoupling the voting application from downstream processing. Dataflow provides flexible, scalable processing to load data into Bigtable for low-latency, real-time partial results during the voting window. BigQuery is used for cost-effective, exact-once final counts and later analysis. Shutting down Bigtable after voting minimizes cost, as it's only needed for real-time results. Memorystore is an in-memory cache, not ideal for persistent, exact-once counting. Cloud SQL is a relational database, which struggles with the high write throughput of a voting spike and is less cost-effective for real-time analytics at scale compared to Bigtable. Using Cloud Functions to write directly to BigQuery might not handle the sustained high write volume efficiently and could lead to higher costs and potential rate limiting issues compared to a Dataflow pipeline.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed