DP-600 · Question #202
DP-600 Question #202: Real Exam Question with Answer & Explanation
Sign in or unlock DP-600 to reveal the answer and full explanation for question #202. The question stem and answer options stay visible for context.
Question
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?
Options
- Aa many-to-many relationship between FactTransaction and Dim Customer
- Ba bridge table with relationships to DimCustomer and DimAccount
- Ca bridge table with relationships to FactTransaction and DimCustomer
- Dthe CustomerKey column in FactTransaction and a relationship to DimCustomer
Unlock DP-600 to see the answer
You've previewed enough free DP-600 questions. Unlock DP-600 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.