Câu 36: 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012

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 salesYou 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.)

1. A. Place the measures in a single measure group.
2. B. Place the distinct count measures in separate measure groups. — đáp án hiện tại
3. C. Use the additive measure group functions.
4. D. Use the semiadditive measure group functions.
5. E. Use the Count and Sum measure aggregation functions.
6. F. Use the Distinct Count and Sum measure aggregation functions. — đáp án hiện tại