Free COF-C02 Exam Braindumps
SnowPro Core Questions 406–410 (page: 83)

Updated On: 10-Feb-2026

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

  1. Configure the warehouse to a size larger than generally required
  2. Set the minimum and maximum clusters to autoscale
  3. Use the standard warehouse scaling policy
  4. Use the economy warehouse scaling policy

Answer(s): C



During periods of warehouse contention, which parameter controls the maximum length of time a warehouse will hold a query for processing?

  1. STATEMENT_TIMEOUT_IN_SECONDS
  2. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
  3. MAX_CONCURRENCY_LEVEL
  4. QUERY_TIMEOUT_IN_SECONDS

Answer(s): B



Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

  1. PURGE
  2. MODIFY
  3. REMOVE
  4. DELETE

Answer(s): C



In a Snowflake role hierarchy, what is the top-level role?

  1. SYSADMIN
  2. ORGADMIN
  3. ACCOUNTADMIN
  4. SECURITYADMIN

Answer(s): C



By default, which Snowflake role is required to create a share?

  1. ORGADMIN
  2. SECURITYADMIN
  3. SHAREADMIN
  4. ACCOUNTADMIN

Answer(s): D



Viewing page 83 of 221
Viewing questions 411 - 415 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!