Answer-first summary for fast verification
Answer: Utilize the BigQuery Storage Write API and set your target BigQuery table to be regional.
The BigQuery Storage Write API is designed to stream data into BigQuery with exactly-once delivery semantics, ensuring each record is written exactly once. A regional target table in BigQuery provides the necessary redundancy within a single region for high availability and durability. Given the high throughput requirement of 1.5 GB per second, the Storage Write API is more suited for reliable and efficient data streaming. Options B and D are incorrect because the BigQuery Streaming API does not guarantee exactly-once delivery semantics, making it less suitable for this high-throughput scenario. Options C and D suggest using multiregional tables, which are not required here as they are intended for global data distribution and redundancy, beyond the scenario's needs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In a scenario where a Dataflow streaming job processes messages from a message bus that does not support exactly-once delivery, applies transformations, and then loads the results into BigQuery, how can you ensure exactly-once delivery semantics at an ingestion throughput of about 1.5 GB per second?
A
Utilize the BigQuery Storage Write API and set your target BigQuery table to be regional.
B
Opt for the BigQuery Streaming API and ensure your target BigQuery table is regional.
C
Choose the BigQuery Storage Write API and make sure your target BigQuery table is multiregional.
D
Select the BigQuery Streaming API and confirm your target BigQuery table is multiregional.
No comments yet.