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. Whic

DirectQuery with In-Memory designates DirectQuery as the primary mode while permitting some cached results, meaning queries can bypass the cache and go directly to the relational source.

In-Memory mode uses the VertiPaq in-memory analytics engine to store all data compressed in RAM. Every query is resolved entirely from the in-memory cache with no DirectQuery fallback possible, which directly satisfies the requirement that queries must be resolved only by using cache.

In-Memory with DirectQuery sets In-Memory as the primary mode but still permits DirectQuery fallback for queries or partitions that require it, so not all queries are guaranteed to be resolved from cache.

DirectQuery mode bypasses the in-memory cache entirely and sends all queries directly to the relational data source at query time.