Which type of table should an insurance company use to store supplier attribute details for aggregating claims?

• A. Fact table.
• B. Dimension table.
• C. Staging table.
• D. Lookup table.

Answer: (B)

In this scenario you want to analyze and aggregate claims by the details of suppliers. In dimensional modeling, descriptive attributes that you want to group by or filter on are stored in a dimension table. The fact table would hold the actual measures (like claim amounts or counts) and would reference the supplier dimension through keys, allowing you to roll up the claims by supplier attributes such as name, region, or category. A dimension table provides a stable, query-friendly structure for these attributes and supports consistent joins and hierarchies. Staging tables are used during ETL, and a lookup table is typically a small reference used during transformation rather than the main structure for analysis. So the supplier attribute details belong in a dimension table.