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:

Vertebral Rotation

A condition or occurrence where a vertebra rotates around its axis, which may be associated with various spinal disorders.

Thoracic Spine

The portion of the spine that is located in the chest area, consisting of twelve vertebrae that are attached to the ribcage.

Fractured Hip

A broken bone in the hip, often resulting from trauma or falls, particularly prevalent in the elderly due to osteoporosis.

Musculoskeletal Impairment

A condition that affects the bones, muscles, ligaments, or tendons, leading to limitations in movement or function.