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 31 discussion

Actual exam question from Microsoft's PL-300
Question #: 31
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 the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by fdsdfgxcvbdsfhshfg at Sept. 17, 2022, 4:40 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
fdsdfgxcvbdsfhshfg
Highly Voted 2 years, 7 months ago
Should be Yes. You later use a USERELATIONSHIP() to calculate different measures
upvoted 64 times
NevilleV
2 years, 6 months ago
I believe the correct answer is NO. I think you are jumping the gun. Yes, you can use USERELATIONSHIP() later and yes you will need to add inactive relationships in order to make use of USERELATIONSHIP() ....BUT.... Right now! Does the solution offered in the question, at this point in time, provide the SOLUTION???? NO!!! it doesn't because the solution offered as it stands is incomplete.
upvoted 90 times
Odidepse
3 months, 3 weeks ago
Agree, should be Yes create inactive relationships between the date table and the sales table for the additional foreign keys and using DAX calculations using the USERELATIONSHIP() l function. This approach lets you analyze sales over time using different date columns by creating DAX measures that activate the corresponding inactive relationships. Therefore, adding inactive relationships for the extra date columns achieves the goal.
upvoted 1 times
...
yahsee33
2 years, 4 months ago
But the same thing applies to all three possible solutions. Relationships will need to be added unless they are auto-detected. So it comes down to interpretation of the question, but my read is that "solution" here can mean a partial solution. But not sure.
upvoted 2 times
...
GuerreiroJunior
2 years, 4 months ago
I AGREE WITH NEVILLEV
upvoted 2 times
...
Load full discussion...
...
shakes103
2 years, 5 months ago
Lifted from documentation: "By default, active relationships propagate filters to other tables. Inactive relationship, however, only propagate filters when a DAX expression activates (uses) the relationship". Going by this, NO is the answer.
upvoted 17 times
Shalaleh
2 years, 1 month ago
Hey guys, what is the correct answer? we cannot use all relationships in one single measure, but we can use them in different measures.
upvoted 1 times
...
semauni
2 years ago
You can, however, not make multiple active relationships to the same table, in this case date. Or you would need to make three date tables, producing confusing results.
upvoted 1 times
...
...
...
MBA_1990
Highly Voted 2 years, 4 months ago
Selected Answer: B
The Answer is NO. We need at least one active relationship between sales and date table.
upvoted 22 times
...
tckc
Most Recent 2 months ago
Selected Answer: A
If all keys must be used, the USERELATIONSHIP function allows you to do so with inactive relationships.
upvoted 1 times
...
741ed03
2 months, 3 weeks ago
Selected Answer: A
The answer is Yes.
upvoted 1 times
...
hebertorosillo
3 months, 1 week ago
Selected Answer: A
Should be Yes. You later use a USERELATIONSHIP() to calculate different measures
upvoted 1 times
...
chicken_chaser
3 months, 2 weeks ago
Selected Answer: A
The question only ask action that 'Support'. And yes create inactive relationship can support the intended goal by using USERELATIONSHIP() later with DAX
upvoted 1 times
...
tko86
4 months, 2 weeks ago
Selected Answer: A
The answer is Yes. Here's why: Multiple Date Relationships: In Power BI, a table can only have one active relationship with a date table at a time. However, you can create multiple inactive relationships to connect the same date table to different date columns (like your Due Date, Order Date, and Delivery Date). USERELATIONSHIP Function: Inactive relationships aren't used for filtering by default. But, you can activate them within DAX measures using the USERELATIONSHIP function. This allows you to perform time intelligence calculations and analysis based on any of the date foreign keys.
upvoted 3 times
...
jaume
5 months, 2 weeks ago
Selected Answer: B
My vore is for B.No solution. It doesn't matter whether the relationship is active or inactive, data behind the report would remain the same (if you have imported entire dataset, setting a relationship to active/inactive wouldn't not change that)
upvoted 1 times
jaume
5 months, 2 weeks ago
dismiss my comments, I was getting the question was still Q29 as I was expecting a series of questions grouped together but Q29 stands alone and Q29 is different series. In data model, to support the required analysis, relationships MUST be active...you can "activate" any inactive relationship in the datamodel using DAX, but this would be additional step not mentioned in the solution so I would vote for B.No
upvoted 1 times
...
...
23042b9
6 months, 1 week ago
The answer is: No (N) Creating inactive relationships alone does not meet the goal of analyzing sales over time based on all the date foreign keys without using DAX measures to activate those relationships. The answer is: No (N) Creating inactive relationships alone does not meet the goal of analyzing sales over time based on all the date foreign keys without using DAX measures to activate those relationships. The answer is: No (N) Creating inactive relationships alone does not meet the goal of analyzing sales over time based on all the date foreign keys without using DAX measures to activate those relationships.
upvoted 1 times
...
rcaliandro
8 months, 2 weeks ago
Selected Answer: B
No, the inactive relationships doesn't work in the model
upvoted 1 times
...
Inesd
11 months, 3 weeks ago
My question is why should we create a relationship in the first place, if in our sales table we have the sales and the dates, and we want to perform an analysis of sales overtime - why not doing the analysis directly ? and regarding the relationships, not all relationships should be inactive - one of them should be active
upvoted 1 times
...
e3ddceb
11 months, 3 weeks ago
According to git hub copilot A. Yes Explanation: In Power BI, you can create multiple relationships between tables, but only one of those relationships can be active. The active relationship is used automatically in calculations and in visuals. However, you can use inactive relationships by invoking them in DAX formulas using the `USERELATIONSHIP` function. In this scenario, creating inactive relationships for each date foreign key (Due Date, Order Date, Delivery Date) between the sales table and the date table would allow you to analyze sales over time based on all the date foreign keys. You would just need to use the `USERELATIONSHIP` function in your DAX calculations to specify which relationship to use.
upvoted 2 times
...
AZFabio
1 year, 1 month ago
Selected Answer: B
Create 3 Dates dims by adding 2 calc tables based on the existing Dates table
upvoted 1 times
...
asnygen
1 year, 4 months ago
According to chatgpt is Yes ?? whyy
upvoted 1 times
...
RMUK
1 year, 6 months ago
No, Even though we can do achieve it. But I feel its about standard approach in data Model. In this case one active and 2 inactive relationship.
upvoted 1 times
...
rainy_255
1 year, 7 months ago
This was in the exam this week.
upvoted 2 times
...
Igetmyrole
1 year, 7 months ago
B is the correct answer. No, the solution doesn't meet the goal of supporting the analysis of sales over time based on all the date foreign keys. Adding inactive relationships between the sales table and the date table means that those relationships won't be used by default in calculations and visuals. Inactive relationships are typically used for specific scenarios where you want to enable users to switch between different date dimensions interactively.
upvoted 4 times
...
Load full discussion...
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