nerdexam
Microsoft

70-466 · Question #133

You need to modify the environment before you create the QuarterSales report. What should you do?

The correct answer is A. Add a date table to the model that contains columns for the fiscal and calendar quarters.. Creating a QuarterSales report in a Power BI or SSAS Tabular environment requires a dedicated date table containing date attribute columns for fiscal and calendar quarters to enable time intelligence.

Build a tabular data model

Question

You need to modify the environment before you create the QuarterSales report. What should you do?

Options

  • AAdd a date table to the model that contains columns for the fiscal and calendar quarters.
  • BAdd a date table to the model that contains measures for the fiscal and calendar quarters.
  • CConfigure a time dimension by using the Time Intelligence Wizard.
  • DConfigure SSAS to use a server time dimension.

How the community answered

(30 responses)
  • A
    90% (27)
  • C
    3% (1)
  • D
    7% (2)

Why each option

Creating a QuarterSales report in a Power BI or SSAS Tabular environment requires a dedicated date table containing date attribute columns for fiscal and calendar quarters to enable time intelligence.

AAdd a date table to the model that contains columns for the fiscal and calendar quarters.Correct

Power BI and SSAS Tabular time intelligence functions rely on a properly marked date table that exposes date attributes as columns, including fiscal and calendar quarter columns, so the report can group and filter data by those time periods. Without these columns present as table attributes, the report cannot reference quarter-level granularity. Adding this date table is the required prerequisite step before building the QuarterSales report.

BAdd a date table to the model that contains measures for the fiscal and calendar quarters.

Measures are aggregated scalar calculations, not dimensional attributes, so they cannot function as grouping or filtering columns in a date hierarchy.

CConfigure a time dimension by using the Time Intelligence Wizard.

The Time Intelligence Wizard is a feature specific to SSAS Multidimensional and does not exist in the Power BI Desktop or SSAS Tabular environment.

DConfigure SSAS to use a server time dimension.

A server time dimension is an SSAS Multidimensional concept and cannot be configured or applied in a Tabular or Power BI model.

Concept tested: Date table columns for tabular model time intelligence

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

Topics

#date table#tabular model#fiscal quarters#time intelligence

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice