Microsoft
70-768 · Question #58
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…
The correct answer is A. Select the tabular project type and use the In-Memory query mode. See the full explanation below for the reasoning.
Question
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?
Options
- ASelect the tabular project type and use the In-Memory query mode.
- BSelect the multidimensional project type and use the MOLAP storage mode.
- CSelect the multidimensional project type and use the ROLAP storage mode.
- DSelect the tabular project type and use the DirectQuery query mode.
How the community answered
(31 responses)- A74% (23)
- B16% (5)
- C3% (1)
- D6% (2)
Community Discussion
No community discussion yet for this question.