Microsoft Exam Questions

Which query mode should you select?

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