You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are creating a SQL Server Analysis Services (SSAS) cube to return the total value of products
sold in a specified period, the total number of products sold in the specified period and the total
number of each product type sold in the specified period.
The specified period could run up to the current time so the data returned must include up-to-date
information.
Which of the following options should be included to maximize the performance of the query?
(Choose all that apply).
A.
The count measures should be in separate measure groups.
B.
The count measures should be in a single measure group.
C.
The storage mode should be MOLAP (Multidimensional OLAP).
D.
The storage mode should be ROLAP (Relational OLAP).
E.
The Sum measure aggregation function should be included.
F.
The Max measure aggregation function should be included.
G.
The Distinct Count measure aggregation function should be included.
Explanation: