In a data warehouse, which type of table stores descriptive attributes used for analysis, such as region attributes?

• A. Fact
• B. Bridge
• C. Dimensional
• D. Snowflake

Answer: (C)

Descriptive attributes used for analysis are stored in dimensional tables. These tables describe the entities involved in the facts—things like region, product category, time, or customer segment—so you can filter, group, and label your results. They connect to the fact table through keys, allowing you to analyze numeric measures by the descriptive attributes. A fact table holds the quantitative measurements, while a bridge table handles certain relationship complexities between dimensions. A snowflake design refers to how dimension tables are normalized, which can affect how attributes are stored, but the place for descriptive attributes used in analysis is the dimensional (dimension) table.