You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, the queries must be resolved by using cache unless otherwise
specified in the connection string.
You need to configure the appropriate query mode.
Which query mode should you select?
A.
In-Memory with DirectQuery
B.
DirectQuery with In-Memory
C.
In-Memory
D.
DirectQuery
A is the right answer
A
A is the correct answer
Why not C?
A is the correct answer.
http://www.sqlservercentral.com/blogs/jamesserra/2012/06/18/tabular-query-modes-directquery-vs-in-memory/
because:
To maximize performance, the queries must be resolved by using cache “unless otherwise
specified in the connection string”.
+1
“A”
In-Memory with DirectQuery: This is a hybrid mode. By default, queries should be answered by using the In-Memory mode, however, the connection string from the client can instead choose to use the DirectQuery mode.
A confirmed.