Google
PROFESSIONAL-DATA-ENGINEER · Question #393
You need to look at BigQuery data from a specific table multiple times a day. The underlying table you are querying is several petabytes in size, but you want to filter your data and provide simple ag
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #393. The question stem and answer options stay visible for context.
Submitted by parkjh· Mar 30, 2026Designing data processing systems
Question
You need to look at BigQuery data from a specific table multiple times a day. The underlying table you are querying is several petabytes in size, but you want to filter your data and provide simple aggregations to downstream users. You want to run queries faster and get up-to-date insights quicker. What should you do?
Options
- ACreate a transactional database that monitors the pending messages.
- BCreate a new Pub/Sub push subscription to monitor the orders processed in the agent's system.
- CUse Pub/Sub exactly-once delivery in your pull subscription.
- DUse a Deduphcate PTransform in Dataflow before sending the messages to the sales agents.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#BigQuery optimization#query performance#large tables#aggregations