Exam PL-300 topic 9 question 4 discussion

Auto date/time does not meet the criteria: The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements. The correct answer is A

I think that the C option is the correct one. the option A creates an active relationship between Sales.orderDate and Date and a inactive relationship between sales.shippedDate and Date. However we will have visuals where we will have to filter either shippedDate or orderDate, so we will no be able to filter by shipedDate because of the relationship is inactive (we could create measures using the USERELATIONSHIP() function but this is not the case due to we have to use the filters directly from the visuals)

If you are "designing the model" then we should focus on ship date and order date and utilizing userrelationship()

I know "A" could do the job, but does anyone think "D" can also do the work? If so, it creates fewer columns and rows than adds a complete date table.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time

this is weird because in the learning path they explicit state not to use auto date/time as it is bad practice and use date table only. But in this scope... one date table is not enough and it's not mentioned to duplicate the date table. So to fulfill the requirements, the only stable solution I see is D, I do agree It doesn't minimize the size but it doesn't make it that much bigger either... D. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.

The correct answer is A. Any Model should have a Data Table to make it easier for us later to create DAX measures for analysis, hierarchies and so on.

❌A ✔ C/D Things to take take notice of. Power Query is not the best place to create Date table and relationships.

A: for me Also, I notice people mention that since its 2GB it cannot be imported into Power BI. That isn't true. 1) it depends on its finalized compression sizes, not the size of the DB etc and 2) also depends on if they have premium or not

we need a calendar table for current year and last 3 years! Auto data/time increase the size of data model.

In the previous question , where we need to use both order date and shipped date to calculate the late orders,In that case we need both columns as active. So I think its C. If it was an independent question then definitely answer would be C

Answer A does not have correct active/inactive relationship. Order Shipped date should be active. So that leaves C as correct option

I think the answer is A. The inactive relationship on shipping date can be used in a measure with USERELATIONSHIP() function, because nowhere is being filtered on both order date and shipping date at the same time.

A is the answer

C is correct.

--> Top Customers report : "will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.". Therefore you don't need a Dates Table at all. All you need is month and quarter from the sales-date which you will get if you enable auto-dateTime. --> Top Products report "will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category". You don't need a Dates table for this report. With auto-DateTime you can get the month and quarter from the sales-date. --> On-Time Shipping report "will show the following metrics for a selected shipping month or quarter:". Therefore, you don't need a dates table for this report. You only need the shipping month and quarter from the shipping-date which are gonne be automatically created once you will have enabled auto-dateTime