
Answer-first summary for fast verification
Answer: Running a custom query, Running COPY commands
Virtual warehouses in Snowflake consume credits when they are running and performing compute-intensive operations. According to Snowflake documentation and the community discussion consensus (100% agreement on DE with upvoted comments referencing official docs), COPY commands (E) consume warehouse credits because they require compute resources for data loading/unloading operations. Custom queries (D) also consume credits when they execute SQL statements that require compute resources. Options A (caching) and B (EXPLAIN/SHOW commands) do not consume credits as they leverage Snowflake's result cache or metadata operations without requiring warehouse compute. Option C (cloning) is a metadata-only operation that doesn't consume warehouse credits.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.