Which of the following modifications to the cube should you perform?

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
A cube is used by the Marketing department to view the number of product sales. The cube has
two measures in a single measure group. One measure is named Total Products Ordered and the
other is named Products Ordered Per Hour.
You have been asked to configure the cube so that the Total Products Ordered measure is
updated as soon as an order is received. The Products Ordered Per Hour measure needs to be
updated on the hour every hour.
Which of the following modifications to the cube should you perform? (Choose one of more
answers)

A.
You should move the Total Products Ordered to a new measure group.

B.
You should move the Products Ordered Per Hour to a new measure group.

C.
You should configure the new measure group to use the MOLAP (Multidimensional OLAP)
storage mode.

D.
You should configure the new measure group to use the ROLAP (Relational OLAP) storage
mode.

E.
You should configure the current measure group to use the MOLAP (Multidimensional OLAP)
storage mode.

F.
You should configure the current measure group to use the ROLAP (Relational OLAP) storage
mode.

Explanation: