You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL
Azure 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 tabular project type and use the In-Memory query mode.
B.
Select the multidimensional project type and use the MOLAP storage mode.
C.
Select the multidimensional project type and use the ROLAP storage mode.
D.
Select the tabular project type and use the DirectQuery query mode.
A.
Select the tabular project type and use the In-Memory query mode.