フリー問題

問題文

An administrator opens the profile of a slow query and finds a large number of bytes spilled to remote storage. What does that indicate?

選択肢

1. The operation needed more memory than the warehouse had, spilled to local storage, and then exceeded that too, which is the slowest of the three situations.
2. The table's clustering was recomputed during the query, and the reclustering work appears as spilled bytes in the profile.
3. The result set was written to remote storage so that it could be reused by later runs of the same statement, which is expected for a report of this size.
4. Remote spilling is faster than local spilling because remote storage is distributed across many nodes, so the metric is not a concern.