PrepAway - Latest Free Exam Questions & Answers

You need to create a measure that returns the number of customers who have placed orders

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply