QuestionQ20

VerifiedImplement and manage semantic models

You have a semantic model named Model1 that contains data that relates to customers and their bank account balances.

Model1 has the following tables and columns.

Question Image

A customer can have one or more accounts. Each account can be associated to multiple customers.

You need to ensure that users can query Model1 to identify the total transaction amounts by customer.

What should you add to Model1?

Explanation

A many-to-many relationship between customers and accounts requires a bridge table that connects both dimension tables (DimCustomer and DimAccount). This allows FactTransaction rows to correctly aggregate by customer through the bridge mapping.

Community Discussion

No comments yet. Be the first to start the discussion!