Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 31 discussion

Actual exam question from Microsoft's PL-300

Question #: 31
Topic #: 2

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

Suggested Answer: B 🗳️

by fdsdfgxcvbdsfhshfg at Sept. 17, 2022, 4:40 p.m.

Comments

Submit Cancel

fdsdfgxcvbdsfhshfg

Highly Voted 2 years, 9 months ago

Should be Yes. You later use a USERELATIONSHIP() to calculate different measures

upvoted 66 times

NevilleV

2 years, 8 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

5 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, 6 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, 6 months ago

I AGREE WITH NEVILLEV

upvoted 2 times

...

Load full discussion...

...

shakes103

2 years, 7 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, 3 months 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, 2 months 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, 6 months ago

Selected Answer: B

The Answer is NO. We need at least one active relationship between sales and date table.

upvoted 22 times

...

Idmir

Most Recent 4 weeks ago

Selected Answer: A

La respuesta es la A

upvoted 2 times

...

lechuc508

1 month, 1 week ago

Selected Answer: A

"Yes" is correct answer

upvoted 1 times

...

tckc

4 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

4 months, 3 weeks ago

Selected Answer: A

The answer is Yes.

upvoted 1 times

...

hebertorosillo

5 months, 1 week ago

Selected Answer: A

Should be Yes. You later use a USERELATIONSHIP() to calculate different measures

upvoted 1 times

...

chicken_chaser

5 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

6 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

7 months, 1 week 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

7 months, 1 week 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

8 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

10 months, 2 weeks ago

Selected Answer: B

No, the inactive relationships doesn't work in the model

upvoted 1 times

...

Inesd

1 year, 1 month 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

1 year, 1 month 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

...