Google
PROFESSIONAL-DATA-ENGINEER · Question #185
You need to create a near real-time inventory dashboard that reads the main inventory tables in your BigQuery data warehouse. Historical inventory data is stored as inventory balances by item and loca
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #185. The question stem and answer options stay visible for context.
Submitted by tunde_lagos· Mar 30, 2026Designing data processing systems
Question
You need to create a near real-time inventory dashboard that reads the main inventory tables in your BigQuery data warehouse. Historical inventory data is stored as inventory balances by item and location. You have several thousand updates to inventory every hour. You want to maximize performance of the dashboard and ensure that the data is accurate. What should you do?
Options
- ALeverage BigQuery UPDATE statements to update the inventory balances as they are changing.
- BPartition the inventory balance table by item to reduce the amount of data scanned with each inventory update.
- CUse the BigQuery streaming the stream changes into a daily inventory movement table. Calculate balances in a view that joins it to the historical inventory
- DUse the BigQuery bulk loader to batch load inventory changes into a daily inventory movement table.
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 streaming#Real-time analytics#Data warehousing patterns#Near real-time inventory