Exam4Training

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;

Answer: D

Explanation:

Try this your self

CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR);

INSERT INTO SNOWFLAKE VALUES(1111, ‘SNOWFLAKE’);

INSERT INTO SNOWFLAKE VALUES(2222, ‘SNOWFLAKE’);

SHOW TABLES LIKE ‘SNOWFL%’;

SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;

SELECT COUNT(*) FROM SNOWFLAKE;

SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

After running this, please go to query profile for each of the queries . You can go to query profile, by going to HISTORY and then clicking on the relevant query id.

You will see all the queries except the one using GROUP BY has used the metadata repository to retrieve the results. Any query which uses metadata repository does not consume any compute credit.

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version