COF-C02 · Question #152
COF-C02 Question #152: Real Exam Question with Answer & Explanation
The correct answer is B: Stopping the virtual warehouse that the query is running against. 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 cle
Question
What actions will prevent leveraging of the ResultSet cache? (Choose two.)
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
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
Community Discussion
No community discussion yet for this question.