nerdexam
Snowflake

COF-C02 · Question #196

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

The correct answer is B. Running EXPLAIN and SHOW commands D. Running a custom query. Running EXPLAIN and SHOW commands, as well as running a custom query, consume virtual warehouse credits in the Snowflake environment. These activities require computational resources, and therefore, credits are used to account for the usage of these resources.

Snowflake Cloud Data Platform Features and Architecture

Question

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Options

  • ACaching query results
  • BRunning EXPLAIN and SHOW commands
  • CCloning a database
  • DRunning a custom query
  • ERunning COPY commands

How the community answered

(54 responses)
  • A
    2% (1)
  • B
    91% (49)
  • C
    6% (3)
  • E
    2% (1)

Explanation

Running EXPLAIN and SHOW commands, as well as running a custom query, consume virtual warehouse credits in the Snowflake environment. These activities require computational resources, and therefore, credits are used to account for the usage of these resources.

Topics

#Virtual Warehouses#Credit Consumption#Compute Resources#Query Execution

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice