You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution includes a
table named FactOrders that contains two columns as shown in the following table:
You need to create a measure that returns the number of customers who have placed
orders.
What should you do?
A.
Set the Usage property to Count of rows and the Source Column property to OrderKey.
B.
Set the Usage property to Distinct count and the Source Column property to OrderKey.
C.
Set the Usage property to Distinct count and the Source Column property to
CustomerKey.
D.
Set the Usage property to Count of rows and the Source Column property to
CustomerKey.