One of your query is taking a long time to finish, when you open the query profiler you see that lot of data is spilling to the remote disk(Bytes spilled to remote storage).
What may be the cause of this?

• A.The amount of memory available for the servers used to execute the operation might not be sufficient to hold intermediate results
• B.The size of the AWS bucket used to hold the data is not sufficient for the query
• C.Number of disks attached to the virtual warehouse is not enough for the processing

Comment: *

Name: *

Email: *

Verification: *

Who can view account-level Credit and Storage Usage?

• A.STORAGEMONITOR
• B.A role which has been granted the MONITOR USAGE global privilege
• C.STORAGEADMIN
• D.ACCOUNTADMIN

Comment: *

Name: *

Email: *

Verification: *

What is the recommended strategy to choose the right sized warehouse to achieve best performance based on query processing?

• A.Run heterogenous queries on the same warehouse
• B.Run homogenous queries on the same warehouse

Comment: *

Name: *

Email: *

Verification: *