Google Cloud Professional Data Engineer PDE — Topic 1 Question 102

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?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Leverage BigQuery UPDATE statements to update the inventory balances as they are changing. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. This option meets the real-time / low-latency performance requirement.

Google Cloud Professional Data Engineer PDE — Question 102