You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department requires the following set of metrics:
– Unique count of customers
– Unique count of products sold
– Sum of sales
You need to ensure that the cube meets the requirements while optimizing query response time.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
![PrepAway - Latest Free Exam Questions & Answers](https://www.briefmenow.org/img/pa5.jpg)
A.
Use ROLAP storage for all partitions.
B.
Use the Distinct Count and Sum measure aggregation functions.
C.
Use the Define Semiadditive Behavior page to enable semi-additive behavior.
D.
Use the Define Semiadditive Behavior page to disable semi-additive behavior.
E.
Create a single measure group containing all measures
F.
Place the distinct count measures in separate measure groups.