Which of the below commands will use warehouse credits?

Which of the below commands will use warehouse credits?
A . SHOW TABLES LIKE ‘SNOWFL%’;
B . SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;
C . SELECT COUNT(*) FROM SNOWFLAKE;
D . SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

View Answer

Answer: B,C,D

Explanation:

All the SELECT queries will use warehouse credits because they involve processing data, which requires compute resources. The SHOW TABLES command is a metadata operation and typically does not use credits.