Which metrics below will help you take a decision if you need to resize your warehouse?

Which metrics below will help you take a decision if you need to resize your warehouse?
A . QUERY_HISTORY.BYTES_SCANNED
B. QUERY_HISTORY.REMOTE_SPILLAGE_BYTES
C. QUERY_HISTORY.SCANNED_ROWS

View Answer

Answer: A

Explanation:

Be very careful in answering these type of questions. Read it again. You may be tempted to pick up

QUERY_HISTORY.REMOTE_SPILLAGE_BYTES, but there is no metrics like that, the metrics is

BYTES_SPILLED_TO_REMOTE_STORAGE. So the best answer here is

QUERY_HISTORY.BYTES_SCANNED

BYTES_SCANNED – Number of bytes scanned by this statement.

Scaling up a warehouse is about increasing the compute power of the existing warehouse nodes. This should improve the long running queries that requires to scan a lot of bytes with storage spilling to local or remote(which is the worst). The time taken to execute the query and bytes scanned may indicate a larger warehouse is required.