Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You have been tasked with creating a near real-time inventory dashboard that reads from the main inventory tables in your BigQuery data warehouse. The historical inventory data is stored in the form of inventory balances categorized by item and location. The inventory system receives several thousand updates every hour. Your goal is to maximize the performance of the dashboard while ensuring the accuracy of the data. What steps should you take to accomplish this?
A
Leverage BigQuery UPDATE statements to update the inventory balances as they are changing.
B
Partition the inventory balance table by item to reduce the amount of data scanned with each inventory update.
C
Use the BigQuery streaming to stream changes into a daily inventory movement table. Calculate balances in a view that joins it to the historical inventory balance table. Update the inventory balance table nightly.
D
Use the BigQuery bulk loader to batch load inventory changes into a daily inventory movement table. Calculate balances in a view that joins it to the historical inventory balance table. Update the inventory balance table nightly.