What should you include in your design?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
An Analysis Services cube you are developing for the Marketing department contains a measure
group named Customers.
You need to be able to determine the number of unique customers.
What should you include in your design?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
An Analysis Services cube you are developing for the Marketing department contains a measure
group named Customers.
You need to be able to determine the number of unique customers.
What should you include in your design?

A.
A measure with an expression that calculates a value using the FirstNonEmpty and
LastNonEmpty functions.

B.
A measure that uses the DistinctCount aggregate function.

C.
A measure with an expression that calculates a value using the Min and Max functions.

D.
A measure that uses the Count aggregate function.

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *