In Data Warehouses and Data Marts, Data Are Stored in a Multidimensional

question 39

Multiple Choice

In data warehouses and data marts, data are stored in a multidimensional structure and visually represented as a data cube. Figure 3.12 is an example of a data cube of sales with the dimensions of product, geographic area, and time period (year) . These are called business dimensions. What would the business dimensions be for Walmart's sales with its many sales transactions for many products in many stores that would allow them to do weekly analysis?

• A) Customer, product, and month
• B) Customer, product, store
• C) Customer, product, store, and month
• D) Customer, product, store, and week
• E) Product, store, and week

---

Definitions:

Capital Intensity Ratio

A metric that measures the amount of assets required to generate a dollar of revenue, indicating how much capital is invested in production.

Total Liabilities

The combined debts and obligations that a company or individual owes to outside parties, indicating the total amount owed.

Net Income

Company's earnings following the deduction of all expenses and taxes from total revenue.

Capital Intensity Ratio

A financial metric that estimates the amount of investment in capital assets a company needs relative to its labor force to generate revenue.