What actions will prevent leveraging of the ResultSet cache? (Choose two.)

The correct answer is B. Stopping the virtual warehouse that the query is running against D. Executing the RESULTS_SCAN() table function. The ResultSet cache is leveraged to quickly return results for repeated queries. Actions that prevent leveraging this cache include stopping the virtual warehouse that the query is running against (B) and executing the RESULTS_SCAN() table function (D). Stopping the warehouse…

Performance Management

Question

Options

ARemoving a column from the query SELECT list
BStopping the virtual warehouse that the query is running against
CClustering of the data used by the query
DExecuting the RESULTS_SCAN() table function
EChanging a column that is not in the cached query

How the community answered

(39 responses)

A
3% (1)
B
82% (32)
C
5% (2)
E
10% (4)

Explanation

The ResultSet cache is leveraged to quickly return results for repeated queries. Actions that prevent leveraging this cache include stopping the virtual warehouse that the query is running against (B) and executing the RESULTS_SCAN() table function (D). Stopping the warehouse clears the local disk cache, including the ResultSet cache. The RESULTS_SCAN() function is used to retrieve the result of a previously executed query, which bypasses the need for the ResultSet cache.

Topics

#ResultSet Cache#Query Performance#Virtual Warehouse#Query History

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice