Exam PL-300 topic 2 question 55 discussion

AC is the correct answer. According to https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables, marking a table as a Date Table automatically removes the auto-generated date table.

This is the tricky question. If I could, I would go with A, B and C. As, first, you'll need to create a date table and mark it as the Date Table. Second you'll need to create the relationship between this table and the Sales table. And lastly, you will need to disable auto date and time option, as per this article, it will decrease the model size. Option A and C does not decrease the model size. Marking a table as a Date table does not automatically remove the auto-hierarchies in other tables, which makes your data model bigger, so you DO need to disable the auto date/time option.

B.Disable the auto date/time option to prevent Power BI from creating hidden date tables. C.Create a custom Date table and mark it as the Date table for time-based analysis. creating a custom Date table does not automatically disable the auto date/time feature in Power BI. The auto date/time option is a global setting that applies to the entire data model, and it continues to create hidden date tables for every date column in your model unless you explicitly disable it. A. Create a relationship between the Date table and the Sales table: is necessary for analyzing sales over time, but it is not directly related to reducing the size of the data model. It is a standard practice when working with a Date table.

Disabling auto date/time prevents the creation of hidden date tables that increase the model size. Creating a dedicated Date table and marking it as a Date Table ensures that you can still perform time-based analysis without the model size being impacted by unnecessary auto-generated date tables.

In Power BI, if Auto Date/Time is enabled, every Date column (e.g., Order Date, Ship Date, Delivered Date) will automatically generate separate hidden date tables. This increases the model size unnecessarily, especially if there are multiple date columns. Disabling Auto Date/Time (Option B) removes these extra hidden tables and significantly reduces model size. If Auto Date/Time is enabled, Power BI already has hidden date tables, so adding a relationship to another Date table does not reduce size. Only after disabling Auto Date/Time, a custom Date table should be created and linked to Sales for better time intelligence.

When the auto date/time option is enabled, Power BI automatically generates a hidden date table for each date column in your data model. These hidden tables are used for time-based operations like year, month, and quarter analysis. Creating a Date table and marking it as the "Date Table" ensures that the table is used for time intelligence functions. However, the auto date/time option remains enabled unless you explicitly disable it. If you create your own Date table but do not disable the auto date/time option, Power BI will still generate hidden date tables for all date columns. This increases the size of the data model unnecessarily. Disabling the auto date/time option ensures that only your custom Date table is used, reducing model size and improving performance.

Perfectly explained by ak57: Smaller Model Size: By using a custom date table, you avoid the need for multiple auto-generated date tables that Power BI creates by default for each date column in your dataset, leading to a smaller, more efficient model.

AB is the right answer because disabling auto date/time helps to reduce the size

BC: When you mark a Date table you don't need to create a relationship to work with DAX time intelligence. Only for filtering you need to create relationships.

A and C: Smaller Model Size: By using a custom date table, you avoid the need for multiple auto-generated date tables that Power BI creates by default for each date column in your dataset, leading to a smaller, more efficient model.

I chose B and C as a result, knowing that it would be incomplete without creating the relationship (A) but choosing B would reduce the model size while still getting halfway to the required analysis stage.

It does make sense B and C, but in order to optimize query performances also B (Disable the auto date/time option) should be correct, right?

Correct

The answer is BC, AC will not reduce the model size. BC on the other will reduce the model size since you disable auto date/time, and when you mark the date table as the date table the relationship will become automatic, there is no obligation to connect them to do the analysis.

The questions informs that a one-to-many relationship exists between the tables, so I would go B and C

chatgpt> BC is correct

Answer - A & C Creating a Date table and selecting Mark as Date Table will automatically disable the auto date/time option in Power BI. This is because Power BI recognizes the designated Date table as the primary source of date information for the data model. When a Date table is marked as such, Power BI will use the date values from this table for all date-related calculations and visualizations. As a result, the auto date/time option becomes redundant and is automatically disabled to avoid potential conflicts or inconsistencies.