Microsoft
70-448 · Question #275
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…
The correct answer is C. Set the Usage property to Distinct count and the Source Column property to CustomerKey. See the full explanation below for the reasoning.
Question
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?
Options
- ASet the Usage property to Count of rows and the Source Column property to OrderKey.
- BSet the Usage property to Distinct count and the Source Column property to OrderKey.
- CSet the Usage property to Distinct count and the Source Column property to CustomerKey.
- DSet the Usage property to Count of rows and the Source Column property to CustomerKey.
How the community answered
(59 responses)- A5% (3)
- B3% (2)
- C83% (49)
- D8% (5)
Community Discussion
No community discussion yet for this question.