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:

Multiplier

An economic factor that quantifies the impact of increased spending in the economy, leading to a proportional increase in income and consumption.

Marginal Propensity

The proportion of an additional unit of income that is spent on consumption; a key concept in Keynesian economics related to how income changes affect spending.

Simple Multiplier

The Simple Multiplier is an economic concept that quantifies the impact of a change in investment, government spending, or other economic activity on total output or income.

Aggregate Expenditure

Aggregate expenditure is the total amount of spending in an economy, including consumer spending, investment, government spending, and net exports.