COF-R02 Warehouse Practice Questions
The free SnowPro Core Recertification (COF-R02) questions that deal with warehouse, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #2
Which of the following are options when creating a Virtual Warehouse?
Select 2 answers.
Correct answer: A, B
Explanation
When creating a virtual warehouse you can set auto-suspend and auto-resume behavior. Local SSD size and user count are not warehouse creation options; warehouse size and cluster settings drive compute.
Question #6
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.
Correct answer: B
Explanation
Snowpipe uses Snowflake-provided serverless compute rather than a user-managed virtual warehouse, so an active pipe does not require a dedicated warehouse. The statement is false.
Continue with SnowPro Core Recertification (COF-R02)
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in SnowPro Core Recertification (COF-R02), the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
All SnowPro Core Recertification (COF-R02) practice questions →