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:

Loanable Funds

The total resources or funds available for borrowing, typically within a nation's financial markets, where savers supply funds and borrowers demand them.

Interest Income

Earnings received from deposit accounts like savings, or from investments like bonds, calculated as a percentage of the principal.

Loanable Funds Model

An economic model that describes the market where borrowers and lenders interact, determining the equilibrium interest rate and quantity of loanable funds.

Interest Rates

The amount of a loan that is incurred as interest by the borrower, customarily specified as an annual percentage of the loan in question's remaining value.