Answer: Bytes spilled to local storage., Bytes spilled to remote storage.

The question asks for two metrics in a Query Profile that indicate a query was too large to process entirely in memory. In Snowflake, when a query exceeds available memory, data spills to storage. 'Bytes spilled to local storage' (B) refers to spilling to the local disk of the virtual warehouse, and 'Bytes spilled to remote storage' (D) refers to spilling to Snowflake's internal remote storage (cloud storage). These metrics directly show memory insufficiency. Option A (local cache) is incorrect as cache is for reused data, not spillover. Option C (remote cache) is not a standard spill metric. Option E (remote metastore) is unrelated, as the metastore stores metadata, not spilled query data. The community discussion unanimously supports BD with upvoted references to Snowflake documentation.

Author: LeetQuiz Editorial Team