Exercise $2-7$ Static

Which of the following statements about data warehouses and data marts are correct?;

A data warehouse is a subset of the enterprise database that focuses on one particular subject or decision area.

The dimension table describes business dimensions of interest such as customer, product, location, and time, while the fact table contains facts about the business operation.

A star schema represents a multidimensional data model.

A data warehouse is the central repository of data from multiple departments within a business enterprise to support managerial decision$-$making.

Statements $1,3,$ and $4$ are correct. Statement $2$ incorrectly describes the fact table.

Statements $2,3,$ and $4$ correct. Statement $1$ describes a data mart.

Statements $1,2,$ and $4$ are correct. A star schema represents a one$-$dimensional data model.

Statements $1,2,$ and $3$ are correct. Statement $4$ describes a data modeling process.