Microsoft
70-448 · Question #96
You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a table called TestFact which includes two columns listed below for Company.com. In order to develop a measure…
The correct answer is C. You should configure the Usage attribute to Distinct count and the Source Column attribute to CustomerKey. See the full explanation below for the reasoning.
Question
You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a table called TestFact which includes two columns listed below for Company.com. In order to develop a measure which gets the amount of customers who owns placed orders. Which is the correct answer?
Options
- AYou should configure the Usage attribute to Distinct count and the Source Column attribute to OrderKey.
- BYou should configure the Usage attribute to Sum count and the Source Column attribute to OrderKey.
- CYou should configure the Usage attribute to Distinct count and the Source Column attribute to CustomerKey.
- DYou should configure the Usage attribute to Sum count and the Source Column attribute to CustomerKey.
How the community answered
(33 responses)- A6% (2)
- B15% (5)
- C70% (23)
- D9% (3)
Community Discussion
No community discussion yet for this question.