You are designing a SQL Server Analysis Services (SSAS) cube. You need to create a measure to count unique customers. What should you do?

Question

Options

• AUse role playing dimensions.
• BUse the Business Intelligence Wizard to define dimension intelligence.
• CAdd a measure that uses the Count aggregate function to an existing measure group.
• DAdd a measure that uses the DistinctCount aggregate function to an existing measure group.
• EAdd a measure that uses the LastNonEmpty aggregate function.
• FAdd a measure group that has one measure that uses the DistinctCount aggregate function.
• GAdd a calculated measure based on an expression that counts members filtered by the Exists and
• HAdd a hidden measure that uses the Sum aggregate function.
• JCreate a dimension.

• A
  4% (1)
• B
  12% (3)
• C
  4% (1)
• F
  77% (20)
• H
  4% (1)

No community discussion yet for this question.