You need to create relationships to meet the reporting requirements of the customer service department. What should you create?
A.
an additional date table named ShipDate, a one-to-many relationship from Date[date_id] to Sales[Sales_date_id], and a one-to-many relationship from ShipDate[date_id] to Sales[sales_ship_date_id]
B.
an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
C.
a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
D.
a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]
In my opinion, USERELATIONSHIP() can be used here for the inactive relationship between Sales_ship_date_id and Date_id. No need to create a new table.
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
If I'm wrong, please correct me.
I agree. Problem is that D could only be correct if it also specified making a DAX measure using userelationship() and specifying date_id to sales_date_id as 1:* (not vice versa). Would be much better ito performance, but no such requirement is specified.
I agree that the answer should be C. You can have 2 relationships set up for the sales and date tables, only one can be active, and you can turn the appropriate relationship on at will using DAX. No need to clutter the model with extra tables and columns.
A is correct answer. there are 2 ways to solve the problem: Role-playing dimension, and UseRelationship method. Check this link for explanation https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi
on exam - Nov 11, 2021.
my answer:
an additional date table named ShipDate, a one-to-many relationship from Date[date_id] to Sales[Sales_date_id], and a one-to-many relationship from ShipDate[date_id] to Sales[sales_ship_date_id]
the question is what to CREATE. The answer is D. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id] .
Note: 1-to-many is the type of the relationship, not the direction.
Answer: E
Explanation:
Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
For my A. an additional date table named ShipDate, a one-to-many relationship from Date[sales_date_id] to Sales[date_id], and a one-to-many relationship from ShipDate[sales_ship_date_id] to Sales[date_id] is the best option in fact is the best practice for these cases
Honestly, I think none of the answers are correct:
1) Creating a new date table is a bad solution as you bloat up the data model. That rules out A and B.
2) Working with a second (inactive) relation between the sales and date table is the way to go, however both C and D don't work out either since D mixes up the direction of the relationships, and C wants to connect date_id and week_id, which won't work.
This question appears a few pages earlier, too, and there are different answering options. The right is included in that version.
Any thoughts? I'm happy to be convinced otherwise.
Date tables itself aren't big, eventually relationships may take more space when on many side of one-to-many relationship you have millions of rows.
There is nothing about not increasing the size of the model, so still A is valid in this case.
Out of the options given, A is the only one that would work, but if they just phrased it a bit differently, D would be correct and in a real world solution, that is what you'd use.
You'd have 2 relationships from the sales table to the Date table (one would be inactive). To use the inactive one, you'd use the USERELATIONSHIP function in your DAX. The only reason it's not correct is because the way they wrote the many-to-one part is the wrong way around.
A is the correct answers. Since, role-playing dimension is one of the solution to solve active and inactive problem. In addition, relationship is also correct in choice A.
This section is not available anymore. Please use the main Exam Page.DA-100 Exam Questions
Log in to ExamTopics
Sign in:
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.
stokazz
Highly Voted 4 years, 1 month agoDarioReymago
3 years, 7 months agoCherishworth
Highly Voted 4 years agokam5
3 years, 10 months agoMoshekwa
4 years agomanlynn
4 years agobshirer
2 years, 8 months agoMad0701
Most Recent 2 years, 11 months agoTechDiva
3 years, 1 month agoTechDiva
3 years, 1 month agoNhiN
3 years, 1 month agoHazemnz
3 years, 2 months agoPatrickStr
3 years, 4 months agoaguilartu1
3 years, 5 months agokcwood94
3 years, 6 months agoDizzystar
3 years, 7 months agoingie
3 years, 5 months agoezinap
3 years, 7 months agohobob33
3 years, 8 months agoDatabankforfree
3 years, 10 months agoDeathCaliberKnight
4 years agocatalene
4 years, 2 months agoFamerin
4 years, 2 months agotzaganczyk
4 years agouser12345678
2 years, 8 months ago167
4 years, 2 months ago