exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 2 question 7 discussion

Actual exam question from Microsoft's DA-100
Question #: 7
Topic #: 2
[All DA-100 Questions]

HOTSPOT -
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
✑ CustomerID
✑ Customer City
✑ Customer State
✑ Customer Name
✑ Customer Address 1
✑ Customer Address 2
✑ Customer Postal Code
The Invoice table contains the following fields:
✑ Order ID
✑ Invoice ID
✑ Invoice Date
✑ Customer ID
✑ Total Amount
✑ Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
✑ The number of customers invoiced in each state last month
✑ The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: One-to-many -
A customer can have many invoices within one month.

Box 2: Single -
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional). For
Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi- directional.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
stokazz
Highly Voted 4 years, 1 month ago
Pretty sure the answer is correct: One to Many, Single
upvoted 54 times
...
VidSicious
Highly Voted 3 years, 11 months ago
This is quite obvious One-to-many Single
upvoted 14 times
...
SachaBLM
Most Recent 2 years, 3 months ago
I don't get why the answer is "Single" : to get the number of customer invoiced in each state, you need to take all customer for a state, then filter the ones that have been invoiced (information that is in the invoice table)
upvoted 2 times
...
blumek
2 years, 3 months ago
The answer is One-to-many, Single.
upvoted 1 times
...
Dummy92yash
2 years, 7 months ago
One to many, direction both bcoz for first visualisation we have to filter data from invoice to customer and in second from customer to invoice
upvoted 2 times
...
Franz58
2 years, 10 months ago
I created an example, and my previuos comment was wrong, single direction is enough for both requirements. The answer is One-to-many, Single
upvoted 3 times
...
Franz58
2 years, 10 months ago
I think Direction should be both. We need to compute "The number of customers invoiced in each state last month". With single, we can only compute the number of customers per month, like ken281 said, but not the number of customers per state and month. The state is in the Customer table.
upvoted 3 times
...
ken218
3 years, 10 months ago
I originally chose Direction "Both" because I thought I need to group customer by invoice date to fulfill requirement - "The number of customers invoiced in each state last month". But then I realised I can just use Customer ID from the Invoice table to achieve that (I don't need any data from the Customer table for this).
upvoted 10 times
...
commot_check
4 years ago
Yes it is single because gives better performance
upvoted 5 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago