Answer-first summary for fast verification
Answer: Use the BigQuery Storage Write API and ensure that your target BigQuery table is regional.
The correct answer is A. The BigQuery Storage Write API is designed for high-throughput, low-latency writing of data into BigQuery. It also provides tools to prevent data duplication, which is essential for exactly-once delivery semantics. Additionally, ensuring that your target BigQuery table is regional can provide better performance and lower latency if both the Dataflow job and the BigQuery table are in the same region. This setup is more suitable for your high-throughput requirements compared to using the BigQuery Streaming API.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are operating a Dataflow streaming job to ingest messages from a message bus, which inherently does not support exactly-once delivery semantics. The data undergoes various transformations in the process before being loaded into BigQuery. Given the critical requirement that your data must be streamed into BigQuery with exactly-once delivery semantics, and considering that you anticipate an ingestion throughput rate of approximately 1.5 GB per second, what steps should you take to achieve this?
A
Use the BigQuery Storage Write API and ensure that your target BigQuery table is regional.
B
Use the BigQuery Storage Write API and ensure that your target BigQuery table is multiregional.
C
Use the BigQuery Streaming API and ensure that your target BigQuery table is regional.
D
Use the BigQuery Streaming API and ensure that your target BigQuery table is multiregional.
No comments yet.