
Ultimate access to all questions.
You have a semantic model named Model1 containing customer and bank account data. A customer can have multiple accounts, and an account can be associated with multiple customers. You need to enable users to query Model1 to find the total transaction amounts by customer.
What should you add to Model1?

A
a many-to-many relationship between FactTransaction and Dim Customer
B
a bridge table with relationships to DimCustomer and DimAccount
C
a bridge table with relationships to FactTransaction and DimCustomer
D
the CustomerKey column in FactTransaction and a relationship to DimCustomer