Which cache type is used to cache data output from SQL queries?
Which cache type is used to cache data output from SQL queries?
The Result cache is used to cache the output of SQL queries. This type of cache stores the results of queries executed within a certain time period, making it available for subsequent executions of the same queries without having to reprocess the data.
Result Cache: Which holds the results of every query executed in the past 24 hours. These are available across virtual warehouses, so query results returned to one user is available to any other user on the system who executes the same query, provided the underlying data has not changed. Local Disk Cache: Which is used to cache data used by SQL queries. Whenever data is needed for a given query it's retrieved from the Remote Disk storage, and cached in SSD and memory.
Result Query is stored at Cloud Service layer
B. Result cache
result cache
Correct
B is correct