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;
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.
Latest ARA-C01 Dumps Valid Version with 156 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund