PL-300 Model the data Practice Question
Which TWO are valid reasons to use a date table in a Power BI semantic model? (Select two.)
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
To enable time intelligence functions like TOTALYTD and SAMEPERIODLASTYEAR.
Option C is correct because time intelligence DAX functions such as TOTALYTD, SAMEPERIODLASTYEAR, DATESYTD, and DATEADD require a contiguous, marked date table with a Date column at day granularity; without a proper date table these functions return incorrect or blank results. Option E is correct because a single shared date table can be related to multiple fact tables, letting one slicer or filter on the date dimension consistently filter all facts instead of relying on each fact's own date column. Options A, B, and D are not valid reasons: drill-down works with any hierarchy, not specifically a date table; Power BI can auto-generate date hierarchies from a date field without a dedicated date table; and relationship performance depends on cardinality, cross-filter direction, and model design rather than on the presence of a date table.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
To allow users to drill down into non-date hierarchies.
Why it's wrong here
Date tables are specifically structured to support date-based hierarchies such as Year, Quarter, Month, and Day. They do not enable drill-down into non-date hierarchies, like product categories or geographic levels; those require separate dimension tables with their own established hierarchies. A date table only affects date-related dimension analysis, so this is not a valid reason.
- ✗
To automatically generate date hierarchies in visuals.
Why it's wrong here
Power BI automatically creates a date hierarchy for any date column in your data model through the auto date/time feature, regardless of whether you add a dedicated date table. The automatic hierarchy is generated in the background and enables drill-down through Year, Quarter, Month, and Day. A marked date table is not required for this automatic generation; in fact, the auto date/time feature can be disabled if you use a custom date table.
- ✓
To enable time intelligence functions like TOTALYTD and SAMEPERIODLASTYEAR.
Why this is correct
DAX time intelligence functions such as TOTALYTD and SAMEPERIODLASTYEAR require a continuous, contiguous set of dates and a proper filter context over a date column. A date table marked as a date table in Power BI Desktop fulfills this by providing an unambiguous date column and a relationship to your fact tables, ensuring the functions return accurate results. Without a marked date table, these functions may produce incorrect or missing values, especially when your fact dates are sparse or discontinuous.
- ✗
To improve the performance of relationships between tables.
Why it's wrong here
The performance of relationships between tables is primarily determined by the data types, cardinality, and storage engine optimization of the key columns, not by the presence of a date table. Adding a date table does not inherently speed up join operations or query execution; rather, it can sometimes slightly increase model size and overhead. Therefore, using a date table for relationship performance is not a valid reason, as its true benefits lie elsewhere.
- ✓
To ensure consistent date filtering across multiple fact tables.
Why this is correct
When multiple fact tables contain date fields, a single marked date table connected to each fact table creates a star schema that ensures all facts are filtered consistently by the same date dimension. This avoids issues like different date ranges or mismatched calendars, and allows slicers and page-level filters to affect every fact table uniformly. A shared date table is the only reliable way to enforce consistent date filtering across all related tables.
Go deeper
Related to this question
About these practice questions
One of 524 original PL-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.