COF-C02 · Question #295
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
The correct answer is A. Bytes spilled to local cache. B. Bytes spilled to local storage. 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…
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.
How the community answered
(33 responses)- A91% (30)
- C6% (2)
- E3% (1)
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.