In: Computer Science
Because data warehouses are highly de-normalized, they are highly redundant.
A True
B False
Which of the following measure is fully additive?
After conducting requirements analysis for a data warehouse, it is found that “region” is one of the decision dimensions. The sales are analyzed by zip code, city, state and region. The representation zip → city → state → region is considered a ______.
A Region scale
B Normalization
C Hierarchy
D All of the above
In above problem, the finest granularity is represented by:
A Zip
B City
C State
D Region
E Insufficient information to determine
A surrogate key has following ____ characteristic(s).
A Only used in dimension tables
B . System-generated
C . Non-composite
D (B) and (C)
E (A), (B), and (C)
As for a FACT Table in a data warehouse, which following is NOT TRUE.
A A fact table contains attributes that are typically numeric.
B Besides keys it contains only one numerical value known as measure.
C. Each record in fact table represents data about an event arising from interaction of all of the dimensions.
D. A fact table contains fact-measure attributes and foreign keys that connect the fact table to the dimension tables.
Which of the following is not true of a data warehouse?
a. The data warehouse is physically separated from all other operational systems.
b. The data warehouse replaces the need for all other reporting systems within an organization.
c. The data warehouse holds aggregated data and detailed data for management.
d. None of the above.
Because data warehouses are highly de-normalized, they are highly redundant.
Which of the following measure is fully additive?
After conducting requirements analysis for a data warehouse, it is found that “region” is one of the decision dimensions. The sales are analyzed by zip code, city, state and region. The representation zip → city → state → region is considered a ______.
In above problem, the finest granularity is represented by:
A surrogate key has following ____ characteristic(s).
As for a FACT Table in a data warehouse, which following is NOT TRUE.
Which of the following is not true of a data warehouse?