Answer-first summary for fast verification
Answer: Snowflake will charge for 60 seconds at the rate of 32 credits per hour.
The correct answer is C because a 2X-Large virtual warehouse in Snowflake consumes 32 credits per hour, according to the official documentation (https://docs.snowflake.com/en/user-guide/warehouses-overview). Snowflake charges a minimum of 60 seconds for any query execution, even if the actual runtime is less.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A user executes a query that runs for 36 seconds on a 2XL virtual warehouse in Snowflake. How many credits are consumed?
A
Snowflake will charge for 36 seconds at the rate of 32 credits per hour.
B
Snowflake will charge for 36 seconds at the rate of 64 credits per hour.
C
Snowflake will charge for 60 seconds at the rate of 32 credits per hour.
D
Snowflake will charge for 60 seconds at the rate of 64 credits per hour.