Exam DP-600 Topic 1 Question 45 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 45
Topic #: 1
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.

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?

Suggested Answer: C Vote an answer

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.

by Evangeline at Aug 30, 2026, 03:37 PM

Limited Time Offer

15%

Off

Get Premium DP-600 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10