Topic 1 Question 208

Professional Data Engineer

Topic 1 Question 208
A live TV show asks viewers to cast votes using their mobile phones. The event generates a large volume of data during a 3-minute period. You are in charge of the "Voting infrastructure" and must ensure that the platform can handle the load and that all votes are processed. You must display partial results while voting is open. After voting closes, you need to count the votes exactly once while optimizing cost. What should you do?
- Create a Memorystore instance with a high availability (HA) configuration.
- Create a Cloud SQL for PostgreSQL database with high availability (HA) configuration and multiple read replicas.
- Write votes to a Pub/Sub topic and have Cloud Functions subscribe to it and write votes to BigQuery.
- 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.
ユーザの投票
コメント(5)
- 正解だと思う選択肢: D
  Handling High-Volume Data Ingestion:
  
  Pub/Sub: Decouples vote collection from processing, ensuring scalability and resilience under high load. Dataflow: Efficiently ingests and processes large data streams, scaling as needed. Real-Time Results with Exactly-Once Processing:
  
  Bigtable: Optimized for low-latency, high-throughput reads and writes, ideal for real-time partial results. Exactly-Once Semantics: Dataflow guarantees each vote is processed only once, ensuring accurate counts. Cost Optimization:
  
  Temporary Bigtable Instance: Running Bigtable only during voting minimizes costs. BigQuery Storage: Cost-effective for long-term storage and analysis.
  
  👍 2
  e70ea9e2023/12/30
- 正解だと思う選択肢: D
  Answer is D:
  
  Google Cloud Pub/Sub can manage the high-volume data ingestion.
  
  Google Cloud Dataflow can efficiently process and route data to both Bigtable and BigQuery.
  
  Bigtable is excellent for handling high-throughput writes and reads, making it suitable for real-time vote tallying.
  
  BigQuery is ideal for exact vote counting and deeper analysis once voting concludes.
  👍 2
  raaad2024/01/02
- 正解だと思う選択肢: C
  Pub/Sub for sure, and Cloud Functions + BigQuery Streaming seems a good solution. Won't use BigTable as need at least 100GB of data (don't thing a voting system could arrive to that amount of data) and needs to "heat" to work right for >10 minutes... and would be $$$ over C solution
  
  👍 1
  Smakyel792024/01/07
シャッフルモード

ユーザの投票

コメント(5)