PL-300 Exam - Question 65

Question

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: 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.

Does this meet the goal?

Examice · Accepted Answer

Renaming the date table as Due Date and creating Order Date and Delivery Date as calculated tables does not meet the goal of supporting the analysis of sales over time based on all the date foreign keys. The proper approach would involve keeping the date table as a separate entity and establishing relationships between this date table and the sales table using the respective date foreign keys: Due Date, Order Date, and Delivery Date. This setup would allow Power BI to perform the necessary time-based analyses by leveraging these relationships to filter and aggregate data accurately.

fred92 · Answer

Yes, that will meet the goal. It will increase the model size, but that was not the question.

poujor · Answer

NO is the Answer. To be able to create the calculations you need the Relationships. They are NOT stated in this suggestion.

RazaTheLegend · Answer

Definitely YES
You should 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.

This question is about an IMPORT table. So the use of a calculated table is recommended.

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

semauni · Answer

No. We're dealing with role-playing dimensions, and creating additional tables will produce confusing results. Guy in a Cube explained this well in his video. We need ONE date table with inactive relationships.
Source: https://www.youtube.com/watch?v=2BxaUXlx3K4
Source: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

PREM77 · Answer

Answer is No.
 Renaming the date table as "Due Date" and creating calculated tables for "Order Date" and "Delivery Date" will not provide the necessary functionality for analyzing sales over time. To achieve the goal, you would typically create relationships between the date table and the sales table based on the respective date foreign keys. This allows Power BI to perform time-based analysis by using the relationships to filter and aggregate data.

Instead of renaming the date table, you should keep it as a separate table, typically named "Date" or "Calendar." Then, you would establish relationships between the date table and the sales table using the respective date foreign keys: Due Date, Order Date, and Delivery Date.

mirzotti · Answer

No, for so many reasons already mentioned by others in this thread. Here is one other reason; only 2 out of 3 tables are mentioned as calculated tables. What happened to 3rd calcluated table? It is missing so it does not meet the goal.

sergeyitaly · Answer

Noone of those who say Yes did not mention about creation relationship in the model. And this is a key element in data analysis. So, the answer is No.

Igetmyrole · Answer

B is the correct answer.
No, this solution does not meet the goal of supporting the analysis of sales over time based on all the date foreign keys. Remaining the date table as "Due Date" and creating calculated tables for Order Date and Delivery Date using DAX expressions does not establish relationships between the sales table and the date table based on the different date foreign keys (Due Date, Order Date, and Delivery Date).

protivitiuser · Answer

after you read this https://learn.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive the answer should be clear

Ryan_042 · Answer

Creating a calculated table does not keep the original table relationship. This solution is even worse than the one using Power Query to duplicate the 3 date tables. If the auto-detect relationship is enabled, at least using Power Query might not require a relationship.

Moppu · Answer

Think the answer should be A, but you need the relationships. Not sure why this question is more one sided than the one above though.

UlyUkr · Answer

I would say NO, since the solution does not specify creating the relationships. Auto detection feature does not guarantee the correct relationships creation.

bakamon · Answer

No, the reference link given in the answer shows that it needs inactive relationship

WRTopics · Answer

No, the correct answer is B.

RMUK · Answer

No, again its about how will you design the data model. Even if you can create multiple date table for each date field. Standard approach in this case should be one date table, 1 active and 2 inactive relationships.

lukelin08 · Answer

A. Yes (is correct) it's not the best method but it works

agelee · Answer

The question is if we do it in PowerQuery Editor. It's not said. In PowerQuery we can create a copy of table by DAX usage and it will work. "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." Departure Airport = 'Arrival Airport'. "Create an active relationship to relate the new table."

PL-300 Exam - Question 65

Discussion