nerdexam
Microsoft

70-467 · Question #108

You need to develop the tabular project to support the date analysis requirements. What should you do?

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.

Design BI data models

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.

How the community answered

(49 responses)
  • A
    8% (4)
  • B
    4% (2)
  • C
    73% (36)
  • D
    14% (7)

Why each option

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.

ACreate one date table named Date.

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.

BCreate two date tables, one named Order Date and one named Ship Date.

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.

CCreate one date table named Date.Correct

A single date table satisfies all date analysis requirements because DAX time intelligence functions require one contiguous, marked date table. Multiple date columns such as Order Date and Ship Date can both relate to the same Date table using role-playing relationships, with inactive relationships activated via USERELATIONSHIP() in measures as needed.

DCreate two date tables, one named Order Date and one named Ship Date.

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

Source: https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables

Topics

#tabular model#date table#time intelligence#SSAS

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-467 Practice