Which two of the following elements are key to maximizing performance in your model?

You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
You are using SQL Server Data Tools (SSDT) to create a BI Semantic Model (BISM).
Your model will pull data from multiple sources. Data latency is acceptable in your model. The
total amount of source data is 15GB.
You have been assigned a Windows Server 2008 R2 server with 48GB of RAM to host your

model.
You need to design your model to maximize performance.
Which two of the following elements are key to maximizing performance in your model? (Choose
two).

A.
The storage mode should be MOLAP (Multidimensional OLAP).

B.
The storage mode should be ROLAP (Relational OLAP).

C.
The project type should be multidimensional.

D.
The project type should be tabular.

E.
The query mode should be DirectQuery.

F.
The query mode should be In-Memory.

Explanation: