ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 77 discussion

Actual exam question from Microsoft's PL-300
Question #: 77
Topic #: 2
[All PL-300 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

• Due Date
• Order Date
• Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by ApacheKafka at Aug. 7, 2023, 11:10 p.m.

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
Submit Cancel
ApacheKafka
Highly Voted 1 year, 8 months ago
100% Just finish reading about that.
upvoted 16 times
...
panic_attack
Highly Voted 1 year, 2 months ago
This was on the exam on 22/2/2024 (:
upvoted 8 times
...
5bf040d
Most Recent 1 month, 2 weeks ago
Selected Answer: B
Ambiguity in Relationships: Power BI only allows one active relationship between two tables at a time. If you create active relationships between the sales table and all three date tables, Power BI will not know which relationship to use for filtering, leading to ambiguity and incorrect results. Inefficient Use of Calculated Tables: Creating calculated tables for Order Date and Delivery Date duplicates data in memory, which increases the size of the model and is not an efficient approach. A better approach would be to create role-playing dimensions by duplicating the date table for each date key (Due Date, Order Date, and Delivery Date) and then creating inactive relationships between the sales table and each date table. Then use DAX measures with the USERELATIONSHIP function to dynamically switch between the relationships
upvoted 1 times
...
jaume
5 months, 1 week ago
Selected Answer: A
Not the most efficient solution as we will triplicated original table with two additional tables I think it would be more efficient setting relationships in the original table (just one relationship can be active) and use DAX expressions to turn inctive relationships into active when required as this solution would not cause data size to grow. Anyway for the specific scenario, A.Yes is my vote
upvoted 1 times
...
rcaliandro
8 months, 1 week ago
Selected Answer: A
Yes, we have 3 active relationships one for each date
upvoted 1 times
...
JudT
1 year ago
A is correct
upvoted 1 times
...
AZFabio
1 year, 1 month ago
Selected Answer: A
Correct
upvoted 1 times
...
KKPanda77
1 year, 2 months ago
Its called Refactoring methodology
upvoted 5 times
...
wethenorth
1 year, 2 months ago
Selected Answer: A
Question says "it can support the anaysis...." by creating three tables and having a relationship of each with fact table let it support the analysis...it's not best from data model size perspective....Ideal step would be to have 1 active, 2 inactive relationship and create DAX userelationship function with inactive columns ... But for this question, it seems A
upvoted 3 times
Paulkuzzio
1 year, 2 months ago
Your explanation is correct but your answer is wrong. This is because power Bi can only allow one active relationship at a time. the others will be inactive until you need them. Check these links: https://support.microsoft.com/en-us/office/create-relationships-in-diagram-view-in-power-pivot-12e00cb6-cb4d-469c-97ce-caa08349ad76#:~:text=Tables%20can%20have%20multiple%20relationships,calculations%20via%20the%20USERELATIONSHIP%20function https://community.fabric.microsoft.com/t5/Desktop/Power-BI-quot-An-Active-relationship-already-exists-between/m-p/768911#:~:text=Proud%20to%20be%20a%20Super%20User Based on the referenced links, I support that the answer is NO: B
upvoted 5 times
...
...
asnygen
1 year, 4 months ago
Chatgpt: NO
upvoted 2 times
Mo2011
11 months, 2 weeks ago
Chatgpt makes mistakes ☺
upvoted 3 times
...
...
Igetmyrole
1 year, 7 months ago
B is the answer. The solution will not meet the goal because renaming the date table in the Fields pane does not create calculated tables for Order Date and Delivery Date. Additionally, creating active relationships between the sales table and each date table would not address the requirement to support the analysis of sales over time based on all three dates simultaneously. To achieve the goal, you should create calculated tables for Order Date and Delivery Date using DAX expressions, and then you should establish active relationships between the sales table and these calculated date tables.
upvoted 3 times
GB32
1 year, 7 months ago
And yes literally that what the solution is lol....
upvoted 1 times
...
...
a22775
1 year, 7 months ago
Can someone tell where is located that "Fields pane"? Is it in powerquey or in Power Bi's report view?
upvoted 2 times
applushka
1 year, 3 months ago
Power Bi's report view https://learn.microsoft.com/en-us/power-bi/create-reports/service-the-report-editor-take-a-tour#the-fields-pane
upvoted 3 times
...
AyoJose
1 year, 7 months ago
Power Bi
upvoted 2 times
...
...
rgabage
1 year, 8 months ago
Selected Answer: A
Correct
upvoted 3 times
...
[Removed]
1 year, 8 months ago
Selected Answer: A
Correct answer
upvoted 4 times
...
Romain_D
1 year, 8 months ago
Selected Answer: B
It's impossible to have active relationships between the sales table and EACH date table
upvoted 1 times
[Removed]
1 year, 8 months ago
It is possible. You will be making connections from three different fields in the fact table to three separate tables.
upvoted 8 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago