You are developing a BI Semantic Model (BISM) that retrieves data from several sources.
These sources include a SQL Azure database and an OData data feed that includes rainfall data for towns on
the east coast of Australia.
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 whendeveloping the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
– Performance must be maximized.
– Data latency of up to one month is acceptable.
You need to choose a project type and a data accessmode to meet the requirements.
What should you do?
A.
In SSDT, select the multidimensional project typeand use the MOLAP storage mode.
B.
In SSDT, select the tabular project type and use the In-Memory query mode.
C.
In SSDT, select the multidimensional project typeand use the ROLAP storage mode.
D.
In SSDT, select the tabular project type and use the DirectQuery query mode.