Microsoft
70-467 · Question #108
70-467 Question #108: Real Exam Question with Answer & Explanation
The correct answer is C: Create one date table named Date.. In SSAS Tabular and Power BI, a single date table named 'Date' combined with role-playing relationships is the recommended pattern for models that have multiple date columns in the fact table.
Question
You need to develop the tabular project to support the date analysis requirements. What should you do?
Options
- ACreate one date table named Date.
- BCreate two date tables, one named Order Date and one named Ship Date.
- CCreate one date table named Date.
- DCreate two date tables, one named Order Date and one named Ship Date.
Explanation
In SSAS Tabular and Power BI, a single date table named 'Date' combined with role-playing relationships is the recommended pattern for models that have multiple date columns in the fact table.
Common mistakes.
- A. This choice is textually identical to C and would yield the same model design - the scenario context designates C as the intended answer, likely because it pairs with a specific role-playing relationship approach described in the case study.
- B. Two separate date tables (Order Date and Ship Date) add unnecessary complexity and redundancy; role-playing relationships on a single Date table are the standard, supported pattern for this requirement.
- D. Two separate date tables duplicate all date rows and force separate time intelligence calculations per table, complicating DAX measures and defeating the purpose of a shared date dimension.
Concept tested. Tabular model date table design with role-playing relationships
Reference. https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables
Community Discussion
No community discussion yet for this question.