nerdexam
Microsoft

70-467 · Question #100

You need to ensure that the Sales Per Capita calculated measure produces correct results. What should you do?

The correct answer is B. Set the Source DataType property of the Population measure to Biglnt. In SSAS, the Source DataType property of a measure controls how the engine reads raw data from the source - setting it to BigInt ensures large integer population values are not truncated during division in the per capita calculation.

Design BI data models

Question

You need to ensure that the Sales Per Capita calculated measure produces correct results. What should you do?

Options

  • ASet the DataType property of the Population column of the FactPopulation data source
  • BSet the Source DataType property of the Population measure to Biglnt.
  • CSet the data type of the Population column of the FactPopulation data warehouse table to
  • DSet the DataType property of the Population measure to Biglnt.

How the community answered

(48 responses)
  • A
    15% (7)
  • B
    75% (36)
  • C
    6% (3)
  • D
    4% (2)

Why each option

In SSAS, the Source DataType property of a measure controls how the engine reads raw data from the source - setting it to BigInt ensures large integer population values are not truncated during division in the per capita calculation.

ASet the DataType property of the Population column of the FactPopulation data source

The DataType property on the column in the data source view does not directly govern how SSAS reads the measure's source values - the measure's own Source DataType property takes precedence.

BSet the Source DataType property of the Population measure to Biglnt.Correct

The Source DataType property on an SSAS measure tells the Analysis Services engine how to interpret the raw column data from the underlying source. If the Population measure's Source DataType is set to a smaller integer type, large values can overflow or be truncated before the division occurs in the Sales Per Capita expression. Setting Source DataType to BigInt ensures the full precision of the population values is preserved during measure evaluation.

CSet the data type of the Population column of the FactPopulation data warehouse table to

Changing the physical data warehouse column type is an ETL/database layer change and does not by itself correct how SSAS interprets or processes the measure's data type within the cube.

DSet the DataType property of the Population measure to Biglnt.

The DataType property of the measure controls the output format returned to clients, not how source data is read; it is the Source DataType that determines how incoming data is interpreted by the engine.

Concept tested: SSAS measure Source DataType property configuration

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/define-measures-in-a-measure-group

Topics

#calculated measure#data type property#Population measure#SSAS source DataType

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice