CompTIA Data+ DA0-002 (V2) Practice Question

When two dimension entities (Customer and Loyalty Program) have a many-to-many relationship, introducing a bridge table-sometimes called a helper or association table-breaks the relationship into two one-to-many joins. The bridge table stores only the surrogate keys (and any optional weighting columns) for each valid customer-program pair. This preserves the single-valued Customer key in the fact table and lets analysts slice measures by loyalty program without double counting. A slowly changing dimension addresses historical attribute changes, a junk dimension bundles unrelated low-cardinality flags, and a degenerate dimension stores identifiers directly in the fact table; none of these resolve a many-to-many relationship between two full dimensions.