Multiple choice technology

The following statements are true for OLAP CACHE.

  1. Query navigation states and query results are stored in the application server memory

  2. If the same query has been executed by another user the result sets can be used if the OLAP cache is active

  3. Reading query results from OLAP cache is faster than reading from the database

  4. The size of the OLAP cache available does depend on the size of Cache memory available on the Users Desktop
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

OLAP cache stores query navigation states and results in application server memory, enabling result sharing across users who execute the same query. Cache reads are faster than database reads since data is pre-computed and stored in memory. The cache size depends on server memory, not user desktop memory.

Keep practicing — related questions