In a data warehouse, which table type is used to store region information for sales analysis?

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

Answer: (A)

A region is a descriptive attribute used to categorize and group sales data, so it belongs in a dimension table. In dimensional modeling, fact tables hold the numeric measures (like sales amount or units sold) and keys to the dimension tables. The region information is not a measure; it provides context for analysis. By storing region details in a region dimension (region_id, region_name, region_code, etc.), you can easily slice and dice the sales fact by geography and enable meaningful hierarchies (e.g., region to country). A bridge table is reserved for resolving complex many-to-many relationships, which isn’t needed for a straightforward region lookup. A snowflake schema would normalize the region data into multiple related tables, which is not necessary for storing the basic region attributes in most analyses.