You are developing a BI Semantic Model (BISM) that retrieves data from several sources
including a Microsoft Azure SQL Database database and an OData data feed. The model
will be deployed to a server with significantly more memory than the total size of the source
data.
You have the data feed URL, which you will use when developing the model in SQL Server
Data Tools (SSDT).
The model must meet the following requirements:
Maximize performance
Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
What should you do?
A.
Select the multidimensional project type and use the ROLAP storage mode.
B.
Select the tabular project type and use the In-Memory query mode.
C.
Select the tabular project type and use the DirectQuery query mode.
D.
Select the multidimensional project type and use the MOLAP storage mode.
The model will be deployed to a server with significantly more memory than the total size of the source data… so take “B”