Microsoft
70-768 · Question #54
You are designing a SQL Server Analysis Services (SSAS) cube.You need to create a measure to count unique customers.What should you do?
The correct answer is D. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship. See the full explanation below for the reasoning.
Question
You are designing a SQL Server Analysis Services (SSAS) cube.You need to create a measure to count unique customers.What should you do?
Options
- AAdd a hidden measure that uses the Sum aggregate function. Add a calculated measure
- BCreate a dimension. Then add a cube dimension and link it several times to the measure group.
- CCreate several dimensions. Add each dimension to the cube.
- DAdd a measure that uses the LastNonEmpty aggregate function. Use a regular relationship
How the community answered
(66 responses)- A3% (2)
- B6% (4)
- C12% (8)
- D79% (52)
Community Discussion
No community discussion yet for this question.