COF-C02 · Question #295
COF-C02 Question #295: Real Exam Question with Answer & Explanation
The correct answer is A: Bytes spilled to local cache.. In a Query Profile, the statistical information that indicates a query is too large to fit in memory includes bytes spilled to local cache and bytes spilled to local storage. These metrics suggest that the working data set of the query exceeded the memory available on the warehou
Question
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
Options
- ABytes spilled to local cache.
- BBytes spilled to local storage.
- CBytes spilled to remote cache.
- DBytes spilled to remote storage.
- EBytes spilled to remote metastore.
Explanation
In a Query Profile, the statistical information that indicates a query is too large to fit in memory includes bytes spilled to local cache and bytes spilled to local storage. These metrics suggest that the working data set of the query exceeded the memory available on the warehouse nodes, causing intermediate results to be written to disk.
Topics
Community Discussion
No community discussion yet for this question.