What does a dimension table contain?
-
Tables with Measures that cannot be added across all dimensions
-
Tables, also known as lookup or reference tables, contain relatively static/ descriptive data
-
Tables, represent data, usually numeric and additive, that can be analyzed and examined
-
None
Dimension tables contain descriptive, contextual attributes that provide meaning to numerical measurements in fact tables. These include relatively static reference data like product names, customer demographics, geographic information, or time periods. Dimensions serve as the 'who, what, where, when' for analytical queries.
To answer this question, let's go through each option:
Option A) Tables with Measures that cannot be added across all dimensions - This option is incorrect because dimension tables do not typically contain measures. Measures are usually stored in fact tables.
Option B) Tables, also known as lookup or reference tables, contain relatively static/descriptive data - This option is correct. Dimension tables are used to store descriptive data about the different dimensions in a data model. These tables contain relatively static data that is used for reference or lookup purposes.
Option C) Tables represent data, usually numeric and additive, that can be analyzed and examined - This option is incorrect. This description is more suitable for fact tables, which contain the quantitative, numeric, and additive data that can be analyzed.
Option D) None - This option is incorrect because dimension tables do exist and serve a specific purpose in data modeling.
The correct answer is B) Tables, also known as lookup or reference tables, contain relatively static/descriptive data. This option is correct because dimension tables typically store descriptive data about the different dimensions in a data model.