ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 286 - PL-300 discussion

Report
Export

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

Answers
A.

Yes

B.

No

Answers
B.

No

Suggested answer: B

Explanation:

You can reference an inactive relationship whit DAX function USERELATIONSHIP(), but using DAX is not mentioned here.

So follow this refactory methodology:

Create a copy of the role-playing table, providing it with a name that reflects its role. If it's an Import table, we recommend defining a calculated table. If it's a DirectQuery table, you can duplicate the

Power Query query.

Source: https://learn.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

asked 05/10/2024
Alex Tzibosnik
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first