Scenario:

Tables:

DimAccount (accounts)

FactTransaction (transactions)

DimCustomer (customers)

Business rule:

A customer can have multiple accounts.

An account can be linked to multiple customers.

Many-to-many relationship.

Requirement: Calculate total transaction amounts by customer.

Analysis:

Direct many-to-many between FactTransaction and DimCustomer would not properly resolve aggregation.

Adding CustomerKey directly in FactTransaction is not possible because transactions link to accounts, not customers directly.

Correct approach: Create a bridge table (CustomerAccount) that maps Customer ↔ Account.

Then link FactTransaction → DimAccount → Bridge → DimCustomer.

Correct Answer:

C. A bridge table with relationships to DimCustomer and DimAccount