Which command will consume credits from a virtual warehouse?

The correct answers are A, B, and D , assuming SNOWFLAKE is a table or queryable object.

Important exam-note correction:

This question is written as a single-answer question, but more than one listed command can consume virtual warehouse credits. Any SELECT query that scans or processes table data generally requires a running virtual warehouse and can consume warehouse credits.

Why A, B, and D are correct:

These are SELECT statements against a table-like object. Query execution that scans or aggregates data uses compute resources from a virtual warehouse.

Examples:

SELECT MAX(UUID) FROM SNOWFLAKE;

SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY UUID;

SELECT COUNT(*) FROM SNOWFLAKE;

These involve SQL query processing and therefore require warehouse compute unless the result is fully served from cache.

Why C is incorrect:

SHOW commands are metadata commands handled by Snowflake’s cloud services layer. They do not require an active virtual warehouse in the same way table-scanning SELECT queries do.

Official Snowflake documentation reference:

Snowflake documentation explains that virtual warehouses provide the compute resources required to execute SQL queries and DML operations. Metadata commands such as SHOW are handled by the cloud services layer.