70-466 Question #87: Real Exam Question with Answer & Explanation

The correct answer is B: Distinct Count. This question tests which SSAS aggregate function type is used to count unique values for measures such as distinct sales territories or distinct products.

Build an analysis services database

Question

You need to create the sales territory and product measures. Which aggregate function should you use for both measures?

Options

ACOUNT (DISTINCT column_name)
BDistinct Count
CDistinct
DCount

Explanation

This question tests which SSAS aggregate function type is used to count unique values for measures such as distinct sales territories or distinct products.

Common mistakes.

A. COUNT(DISTINCT column_name) is T-SQL syntax used in relational queries; it is not a valid SSAS measure aggregate function type selectable in the Multidimensional model designer.
C. Distinct is not a recognized aggregate function type in SSAS Multidimensional or Tabular; it does not exist as a selectable aggregation option for measures.
D. Count counts all rows including duplicates and does not deduplicate values, so it would overcount when the goal is to measure the number of unique territories or products.

Concept tested. SSAS Distinct Count aggregate function for measures

Reference. https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/use-aggregate-functions

Topics

#aggregate functions#distinct count#measures#cube design

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice