You Need to Create a near Real-Time Inventory Dashboard That

question 19

Multiple Choice

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.

---

Definitions:

Erie Canal

The Erie Canal is a significant historical waterway in New York, opened in 1825, which played a critical role in the commercial expansion of the United States by connecting the Great Lakes to the Atlantic Ocean.

Great Lakes

are a group of five large freshwater lakes in North America, forming the largest group of freshwater lakes in the world by total area.

Upper Midwest

The Upper Midwest refers to the northern central part of the United States, including states like Minnesota, Wisconsin, and Michigan, known for its distinct seasons and agricultural productivity.

Irish Migration

The movement of Irish people to other countries, notably to the United States in the 19th and early 20th centuries, often driven by famine and economic issues.