nerdexam
Snowflake

COF-C02 · Question #554

Which virtual warehouse consideration can help lower compute resource credit consumption?

The correct answer is C. Automating the virtual warehouse suspension and resumption settings. Credits are consumed only while a virtual warehouse is running. Automating suspension (via auto-suspend) ensures the warehouse stops consuming credits when idle, and automating resumption (via auto-resume) ensures it restarts automatically when needed. This directly minimizes…

Performance Management

Question

Which virtual warehouse consideration can help lower compute resource credit consumption?

Options

  • ASetting up a multi-cluster virtual warehouse
  • BResizing the virtual warehouse to a larger size
  • CAutomating the virtual warehouse suspension and resumption settings
  • DIncreasing the maximum cluster count parameter for a multi-cluster virtual warehouse

How the community answered

(65 responses)
  • A
    3% (2)
  • B
    6% (4)
  • C
    89% (58)
  • D
    2% (1)

Explanation

Credits are consumed only while a virtual warehouse is running. Automating suspension (via auto-suspend) ensures the warehouse stops consuming credits when idle, and automating resumption (via auto-resume) ensures it restarts automatically when needed. This directly minimizes wasted compute spend. Resizing to a larger size increases credit consumption per minute. Setting up or expanding a multi-cluster warehouse adds more clusters, which also increases overall credit usage rather than reducing it.

Topics

#Virtual Warehouse#Credit Consumption#Cost Optimization#Warehouse Suspension

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice