Microsoft
70-768 · Question #51
You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, queries must be resolved only by using cache. You need to configure the appropriate query mode…
The correct answer is C. In-Memory. See the full explanation below for the reasoning.
Question
You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, queries must be resolved only by using cache. You need to configure the appropriate query mode. Which query mode should you select?
Options
- ADirectQuery with In-Memory
- BDirectQuery
- CIn-Memory
- DIn-Memory with DirectQuery
How the community answered
(63 responses)- A8% (5)
- B3% (2)
- C71% (45)
- D17% (11)
Community Discussion
No community discussion yet for this question.