You need to create relationships to meet the reporting requirements of the customer service department. What should you create?
A.
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]
B.
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]
C.
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]
D.
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_skip_date_id]
GUYS ATTENTION!
There were 6-7 new questions, one of them I remember was:
Do you have a power BI Report Visual (foto of a visual dashboard report)
What can you do to make it color user friendly for visual defficiency? Choose 2 options, options: Sentiment colors, Theme colors, Divergent colors, First-level colors.
My answers were: Theme colors and divergent colors.
Good luck!
Answer A is wrong as you cannot link Date[Date_Id] to Weekly[Week_Id] as they are different entities. Answer D is right one. You can create two separate date dimension for sales date and ship date and link to date table with many one relationship
The answer is D but i don't know if this is a tricky if you notice it Sales[sales_skip_date_id] it's write as skip not ship
There are spelling mistakes
I think B would have been the best option if not for the fact that we still have to use USERELATIONSHIP() to activate the second relationship with ship_date.
But D has all the requirement and hence the Best Option.
The customer department requires two dates (sales date & ship date) to filter the report by, so they will need another date table. This answer is shown correctly in DA-100: https://www.examtopics.com/discussions/microsoft/view/41209-exam-da-100-topic-8-question-3-discussion/
Creating two 1:* relationships, one of them being inactive, and the DAX function USERELATIONSHIP() will satisfy the reporting requirements.
https://learn.microsoft.com/en-us/training/modules/create-measures-dax-power-bi/4-relationships
A seems to be correct for me but the requirement says "The customer service department requires a visual that can be filtered by both sales month and ship month independently" means we need to create another date table for Ship date.
This section is not available anymore. Please use the main Exam Page.PL-300 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.
fdsdfgxcvbdsfhshfg
Highly Voted 2 years, 1 month agoDataEngDP
Highly Voted 6 months, 3 weeks agoJudT
6 months, 2 weeks agoJudT
Most Recent 6 months, 2 weeks agoJane777
8 months, 1 week agoJohnChung
9 months agoMandar77
1 year agoWRTopics
1 year agohussamAlHunaiti
1 year, 1 month agoApacheKafka
1 year, 2 months agoMEG_Florida
1 year, 2 months agoShalaleh
1 year, 6 months agoSanaCanada
1 year, 6 months agoyoussef_yt89
1 year, 10 months agoHoeishetmogelijk
1 year, 10 months agoBooster21
1 year, 11 months agoNotMeAnyWay
2 years agosimba_10
2 years agoajvela
1 year, 6 months agoJudT
6 months, 2 weeks agoINDEAVR
1 year, 11 months ago