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

The correct answer is A: Create a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCLUBE statement to define the KPI and target value.. This question tests the correct MDX syntax and workflow for defining a KPI in SSAS, requiring a base measure before the KPI definition statement.

Build a tabular data model

Question

You need to create the KPI in the AdhocReports project. What should you do?

Options

ACreate a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCLUBE statement to define the KPI and target value.
BCreate a measure by using the SUM(OrderQuantity) expression and create a KPI based on the measure. Then set the target value.
CCreate a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.
DCreate a KPI based on the OrderQuantity column and then set the target value.

Explanation

This question tests the correct MDX syntax and workflow for defining a KPI in SSAS, requiring a base measure before the KPI definition statement.

Common mistakes.

B. SUM(OrderQuantity) omits the required MDX brackets around the column name, producing invalid MDX syntax that would fail at parse time.
C. Using COUNT([OrderQuantity]) counts the number of rows rather than summing quantities, which produces an incorrect value for an order quantity KPI.
D. SSAS KPIs cannot be based directly on a raw column - a measure must be created first before a KPI can be defined, making this approach invalid.

Concept tested. Creating SSAS KPI with MDX measure and CREATE KPI CURRENTCUBE

Reference. https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/key-performance-indicators-kpis-in-multidimensional-models

Topics

#SSAS KPI#DAX measures#SUM expression#tabular KPI creation

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice