Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

  1. Home
  2. Discussions
  3. Google
  4. Google Cloud Certified
  5. Professional-Data-Engineer Discussions
  6. Professional-Data-Engineer Exam Topic 3 Question 23 Discussion

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 23 Topic 3 Discussion

 Google Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 23 Topic 3 Discussion

Professional-Data-Engineer Exam Topic 3 Question 23 Discussion:
Question #: 23
Topic #: 3

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?
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 the 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.

Get Premium Professional-Data-Engineer Questions
Actual exam question for Google Professional-Data-Engineer exam by Kai7981 at Nov 10, 2025, 8:23:08 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next