CompTIA Data+ DA0-002 (V2) Practice Question

The correct answer is a fact table. In a star schema, the fact table is the central table that contains the quantitative measurements or 'facts' of a business process, such as sales amounts or quantities sold. It also contains foreign keys that connect to the primary keys of the surrounding dimensional tables.

• A dimensional table provides the descriptive context for the facts (e.g., customer names, product categories, dates) rather than the quantitative measures themselves.
• A bridge table is a specialized table used to resolve a many-to-many relationship between tables, which is not the primary function described.
• A slowly changing dimension (SCD) is a type of dimensional table that tracks changes in attribute values over time, not the central table for transactional measures.